SQL Server connection failure error analysis and exclusion

In the process of using SQL Server, the most common problem that users encounter is that they fail to connect. Generally speaking, there are two ways to connect SQL Server, one is to take advantage of SQL Server's own client tools, such as Enterprise Manager, Query Analyzer, transaction Profiler, and so on, the second is to use the user's own development of client programs, such as ASP script, VB program, etc. The client program also uses ODBC or OLE DB to connect to SQL Server. Next, we'll talk about how to solve the problem of connection failure in terms of these two ways of connecting.

One, "SQL Server does not exist or access is denied"

(Figure 1)

"SQL Server does not exist or access denied" error, usually the most likely to occur, because the cause of the error is more, so need to check more aspects.

Generally speaking, there are several possibilities:

1, network connectivity issues;

2, SQL Server server problem;

3. Server-side network configuration problem;

4, the Client network configuration problem.

First, we check the network connection:

1, Ping the server IP address. First shut down the server and the client firewall, in order to exclude firewall software may be shielding the response to ping,telnet, etc. Then start ping the server IP address, if ping server IP address is not successful, indicating physical connection problems, this time to check hardware devices, such as network cards, HUB, routers and so on.

2, Ping the server name. If failure indicates a problem with name resolution, check to see if the Netbuis protocol is installed, and the DNS service is normal.

Second, use the Telnet command to check the working status of the SQL Server server. If the command succeeds, you can see the cursor flashing in the upper-left corner after the screen flashes, indicating that the SQL Server server is working properly and listening for TCP/IP connections on port 1433, and that the server does not start SQL if the command returns an error message "Cannot open connection" Server service, either the TCP/IP protocol is not enabled on the server side or the server is not listening on SQL Server's default port 1433.