Hi all,
I have sql 2005 and 2000 installed on same machine.
both are ent editions. 2005 is default and 2000 is named instance.
2005 works fine locally and remotely. I can connect to 2000 locally using
machinename\instancename, through isqlw, could register 2000 server in ent
manager but when tried to connect to 2000 from remote machine it gives error
saying "server doesn't exist" .
Do I need to do any settings to solve this problem?
any help will be apreciated.
regards.

What is the status of your SQL Server Browser service?


"k_s" wrote:

It's running. I checked it with surface area configuration

"Umut Nazlica" wrote:

Hi

Can you telnet to 2000 instance using IP address and port number?

telnet <ip> <port>

What MDAC version installed on your client?

Are you able to connect to instance with creating an alias using TCP/IP
library, ip address of the server and using static port number by entering
the named instance port and disable dynamically determine port? Can you
perform a ODBC test using this alias..


Regards.


"k_s" wrote: