-
In the evening, a colleague contacted me and said that our system prompted "[DBNETLIB][ConnectionOpen(connect()).]SQL Server does not exist or access is denied." He said that it had always been normal before, but it became abnormal after installing SP4 yesterday.
The connection through the query analyzer is normal, and there is nothing abnormal when checking the sql server.
I searched the Internet for information and remotely accessed his machine. I found that I could connect to the database server normally after entering the server name, but not the IP. The problem is related to the TCP/IP protocol.
Follow the online method as follows:
1. CMD->netstat -an Check whether there is a program that opens port 1433 (the port is opened by default after server 7, and closed by default before server 7).
2. Use select @@version in the query analyzer to view the version number:
SQL Server Versions
@Version SQL Server Version Released
6.50.201 SQL Server 6.5 RTM
6.50.213 SQL Server 6.5 with Service Pack 1
6.50.240 SQL Server 6.5 with Service Pack 2
6.50.258 SQL Server 6.5 with Service Pack 3
6.50.281 SQL Server 6.5 with Service Pack 4
6.50.415 SQL Server 6.5 with Service Pack 5
6.50.416 SQL Server 6.5 with Service Pack 5a
7.00.623 SQL Server 7.0/MSDE 1.0 RTM
7.00.699 SQL Server 7.0 SP1 July 1999
7.00.842 SQL Server 7.0 SP2 March 20th, 2000
7.00.961 SQL Server 7.0 SP3 December 15th, 2000
7.00.1063 SQL Server 7.0 SP4
8.00.194 SQL Server 2000 RTM
8.00.384 SQL Server 2000 SP1
8.00.534 SQL Server 2000 SP2 November 30th, 2001
8.00.760 SQL Server 2000 SP3
8.00.2039 SQL Server 2000 SP4
It was found that his machine was 8.00.194 SQL Server 2000 RTM, and sp4 was not installed successfully.
So I asked him to reinstall SQL Server 2000, or connect using the machine name first.
This article comes from the CSDN blog. Please indicate the source when reprinting: http://blog.csdn.net/lopper/archive/2009/12/31/5110251.aspx