Server: Stand alone Windows 2003 R2 Enterprise x64 Edition Service Pack 2
The server has 4 quad-core processors with 32Gb RAM
SQL: 2 instances of SQL Server 2000 Enterprise Edition SP4 with cumulative update version: 8.00.2040
I am trying to connect to the named instance of SQL Server with an ODBC connection. I am a local admin on the server and a sysadmin on both the default instance and the named instance. I get the error message
Connection failed:
SQLState: '01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.
My users are trying to connect via SQL login and are also receiving the same error message.
The default instance is listening on port 1433. The named instance is listening on port 1464. There ...
Go to the complete details ...