We have a default and a named instance of sql server 2000 (sp#3) running on our Win2k server. We just switched to gigabit cards and now we cannot connect to the named instance via TCP/IP on the server using Enterprise Manager, Query Analyzer or ODBC connection or from any client (the application works fine because it connects via ADO).
I checked the port that the instance is listening on, but is there anyway to see if that port is valid or if any other app is using it?
The error we are getting is [TCP/IP Sockets] SQL Server does not exist or access denied.
I checked the port that the instance is listening on, but is there anyway to see if that port is valid or if any other app is using it?
The error we are getting is [TCP/IP Sockets] SQL Server does not exist or access denied.