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
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
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 is no Windows firewall installed on the server.
The annoying thing is that if I click on the button called "Client Configuration" when using the "ODBC Data Source Administrator" dialogue wizard, and I un-tick the radio box called "Dynamically determine port", and hardcode the port 1464 into the dialogue
box, everything works as it should do.
View Complete Post