How do I diagnose an issue connecting to an SQL Server 2000 database?
Posted on 2008-11-12
I have written several applications using Delphi. These applications use ADO to access a SQL Server 2000 database on one of our servers. One system has had the database access stop working. All other systems are still working well. When I try to use Management Studio Express to connect to the database from the computer I get:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Server Network Interfaces, error: 26 - Error locating Server/Instance Specified)(Microsoft SQL Server)
Now, there should be no discussion of whether or not I have TCP/IP enabled on the server as it is working with other systems. There should be no discussion of turning off the firewall on the server as it is working with other systems. From what I have seen there is an issue in how the client talks to the server using UDP. How would I go about trying to diagnose this problem?