Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Connecting to Multiple Instances of 2000

Author  Topic 

nizmaylo
Constraint Violating Yak Guru

258 Posts

Posted - 2001-05-07 : 17:57:08
I'm running two instances of SQL Server 2000 on the same computer. One is set as default and another one is named.
I can work with both from the server, but I can't figure out how to connect to the second one (named one) from a remote computer. When I follow instructions from the books on line, namely, computername\instancename, it fails.
Since it's remote computer, I type the following:
214.45.45(server_addr)\myInstanceName and it doesn't connect.
Any suggestions?

helena
   

- Advertisement -