Sqlserver prompts The Network Adapter cocould not establish the connection

1. Check whether SQL SERVER allows remote access.
Procedure:
1) open "Enterprise Manager", open the console Root Directory> SQL Server Group> database
2) right-click the corresponding database and choose Properties"

3) select the connection tab and check whether the RPC service is selected under remote server connection.

2. Use the telnet IP address 1433 to check whether the system prompts a connection error.
Such as telnet 127.0.0.1 1433
If a black screen is displayed, the port is normal.
If an error is prompted
Check whether the firewall shields the network access port of SQL SERVER or java IDE
If yes, disable the firewall and restart SQL SERVER and java IDE for testing,
If the system still prompts the preceding error, perform the following steps:
3. Check the SQL SERVER port number and whether the TCP/IP protocol is enabled.
Procedure:
1) open "Enterprise Manager", open the console Root Directory> SQL Server Group> database
2) right-click the corresponding database and choose Properties"
3) Select the "General" tab and click "network configuration". If "TCP/IP protocol" is not enabled, add it

4) select "TCP/IP protocol" and click "properties" to check whether the port number is 1433.

5) If the port number is 1433, change it to another port number, modify the jdbc connection statement, and change the port number to the newly enabled port number, such as jdbc: microsoft: sqlserver: // server_name: 1400 (assuming the new port number is 1400)

4. Try each of the following methods:
1) Check whether the SQL server connection is full.

2) for authentication issues.
Go to SQL audit ice manager> specify server> Content> Security. Change verification to SQL server and windows.

3) Click properties to check whether the port is correct.
4) run % MSSQL_HOME %/80/Tools/Binn/SVRNETCN.exe.
Enable TCP/IP.
5) turn off the firewall.

6) update SQL server to sp4:

Http://www.microsoft.com/downloads/details.aspx? Displaylang = zh-cn & FamilyID = 8e2dfc8d-c20e-4446-99a9-b7f0109f8bc5

After my verification, it is generally easy to use to upgrade to sp4!
Pay attention to the upgrade method, instead of double-clicking to run it. This SP4 is the decompression program. You need to specify a directory. c:/is recommended. After decompression, you need to go to the directory to run the setup. bat is the real installation. I don't know why Microsoft doesn't directly call that. Do not understand !!!

The check method is as follows:

Execute the following SQL statement

Print @ version

For SP4, the following version number should appear:

Microsoft SQL Server 2000-8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation

Note that 8.00.2039

The information of other versions is as follows:

SQL Server 2000 version and level

@ VERSION

Product Level

Original SQL Server 2000 version

8.00.194

RTM

Database Components SP1

8.00.384

SP1

Database Components SP2

8.00.534

SP2

Database Components SP3, SP3a

8.00.760

SP3

Ms de 2000 Release

8.00.760

SP3

Database Components SP4

8.00.2039

SP4

7) Finally, please pay attention to the difference between JDBC2.0 and 3.0 http://www.java2000.net/viewthread.jsp? Tid = 367

8) in SQL Server 2005, if
Failed to connect to the host's TCP/IP. Java.net. ConnectException: Connection refused: connect
Sqlserver2005 disables TCP/IP connections by default. How to Start TCP/IP connection,
Open SQL Server Configuration Manager in the/Microsoft SQL Server 2005/Configuration tool/directory, and select the mssqlserver protocol,
Then there is a TCP/IP protocol in the window on the right, start it, stop the sqlserver service, and then start. The problem is solved.