MS SQL client v.s. server

April 2, 2011 at 12:55:31
Specs: Windows XP SP3, 2Gb
I'm kind of novice to db stuff so apologize if my question sounds a little bit silly.
I installed MS SQL Server 2008 R2 Enterprise edition on my server machine.
My desktop is WinXP. I want to have sql client to connect to my sql server. I searched for available clients and google recommended to install SQL Server 2008 Express edition on my WinXP.
My question:1. is it good/acceptable approach ? 2. which part of SQL Server 2008 Express should I install on my WinXP to save space but have only client part?
Thanks in advance

See More: MS SQL client v.s. server

Report •

April 2, 2011 at 13:09:55
You can get a pack that will allow you to install just the client at this link.

Report •

April 2, 2011 at 18:40:15
hi ijack,
thanks for pointing to the site.
I installed 'Microsoft SQL Server 2008 Native Client' but how could I configure/establish connection to my SQL Server? I don't see any interface for this client ...

Appreciate your help.

Report •

April 3, 2011 at 04:33:57
Normally access to remote databases is done within a program, but you should find a command line utility "sqlcmd" as part of the installation. I can't really go into the details of using this command, but there is extensive documentation of SQL Server on MSDN.

For starters try:

sqlcmd /?

to see if it works and view the available options.

Report •

Related Solutions

April 3, 2011 at 05:47:18
I checked that installation of 'Microsoft SQL Server 2008 Native Client' didn't bring sqlcmd. At least I can't find it on my PC.
I'm still stuck with this client ..


Report •

Ask Question