Groups | Blog | Home
all groups > sql server connect > january 2005 >

sql server connect : MSDE 2000 Named instance in conjunction with SQL server 7



iranpessar NO[at]SPAM hotmail.com
1/18/2005 12:47:06 PM
I have SQL server 7 running as a default instance and I'm trying to install
MSDE 2000. I was able to install it as a named instance by running the
following:
setup.exe SAPWD="password" INSTANCENAME="named_instance"
Now I can not connect to the named instance with OSQL. What do I need to do
Jose Molina
1/20/2005 3:28:02 PM
Hi,
Try to connect to the instance as servername\named_instance

Example: If your machine name is MyServer1 and your named instance is
Cyclops then you would refer to the server as MyServer1\Cyclops. If this
will not work for you in the long run, you can always set up an alias on
your client through the Client Network Utility to refer to it in a more
conventional manner.

-Jose Molina


"iranpessar@hotmail.com" <iranpessarhotmailcom@discussions.microsoft.com>
[quoted text, click to view]

AddThis Social Bookmark Button