I am just trying to connect using the following command
c:\>sqlcmd -E
I have another sql server where this command works. The second sql server fails with this command.
However, if I use the following:
c:\>sqlcmd -E -S.\Server
then I can connect into the second sql server.
In the second example you are connecting to a Named Instance of Sql Server. The ".\Server" essentially means LocalHost\Server. You can install Sql Server 2000 forward on the same machine multiple times using Named Instances. When you install the first one and select Default instance you can use the first example, but when you have a named instance you must include the server name (the ".") and the instance name ("Server"). The instance name follows a "\".
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question