What is the Server name syntax for an ODBC to a SQL 2000 instance installed after SQL 2005 default instance?
When I try creating an ODBC connection from a client with MDAC 2.7 it says "Server does not exist or access denied". ODBC to the default instance works fine.

Just the facts:
Server name is SV-01-SQL01
SQL 2005 is default instance, SP1 (installed first, in D:\SQL Server)
SQL 2000 is named instance "SQL2000", SP4 (installed second, in D:\SQL Server 2000)

Named pipes and TCPIP is enabled for both 2005 and 2000
Query analyzer connects to the 2000 instance
MDAC 2.7 installed on a client from which I want to make an ODBC conncetion.

I've tried the following names
SQL2000
SV-01-SQL01\SQL2000
\\SV-01-SQL01\SQL2000
SV-01-SQL01/SQL2000
SV-01-SQL01.SQL2000


Thanks

There are many possible issues.

Try to force Named Pipes...
NP:SV-01-SQL01\SQL2000

Try to force TCP/IP...
TCP:SV-01-SQL01\SQL2000 (dynamic port determination)
TCP:SV-01-SQL01\SQL2000,<port number>

A link to read through to help troubleshoot.
http://support.microsoft.com/kb/328306

HTH

Adam Gossage
Lake Wylie, SC, USA

Using TCP:SV-01-SQL01\SQL2000,port# worked using the default port for sql2000.

Thanks a bunch! (=