Monday, March 19, 2012

New Server Registration offers no Server Name options

Real newbie question this, I suppose. (Apologies if in the wrong forum!)

Have just downloaded and installed SQL Server Express. When I attempt to start it up, the New Server Registration dialogue box appears. When I attempt to enter a Server Name, there are no options in the drop-down box except <Browse for more>, which then offers me neither Local Servers or Network Servers.

The machine is running XP Pro and I wish to use the SQL package to develop on the PC as a stand-alone environment while I evaluate it.

So what am I doing wrong?

Many thanks in advance for any help.

I have been looking through previous threads and camce across an entry from Mike Wachal, who suggested typing the following into a command window.

SQLCmd -S .\sqlexpress -E

The response was 'SQLCmd is not recognized as an internal or external command, operable program or batch file'. Is this anything to do with my problem?

|||

Duh! I realized that I had only downloaded the Management Studio package and not SQL Server itself. All working now ...

No comments:

Post a Comment