Monday, March 26, 2012

MSDE 2000 Named instance in conjunction with SQL server 7

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
to connect properly?
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>
wrote in message news:1FB9C0FC-639B-4B6E-A4EC-6623B70F3F78@.microsoft.com...
>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
> to connect properly?

No comments:

Post a Comment