Common Errors and Solutions

1. jsp cannot connect to the database, and always prompts "failed connection to the host TCP/IP"

Solution:

1 first, you must enter

Exec SYS. sp_readerrorlog 0, 1, 'listencoding'

The running TCP/IP interface of your SQL statement is displayed.

Check whether it is inconsistent with the interface in the URL specified in your Java code

 

2. Check whether the server's TCP/IP is disabled. sqlserver2005 disables TCP/IP connections by default. Start TCP/IP connection: Start \ Program \ Microsoft SQL Server 2005 \ Configuration tool \ directory of SQL Server Configuration Manager, select MSSQLServer protocol, then there is a TCP/IP protocol in the window on the right, and then start it, stop the sqlserver service and start it again.

 

3. Set "Start \ Program \ Microsoft SQL Server 2005 \ Configuration tool \ SQL Server peripheral application configurator" on the "SQL Server 2005 peripheral application configurator" page, click "service and connected peripheral application configurator", click expand "Database Engine", select "remote connection", and select "local connection and remote connection" on the right ", select the Protocol to use (TCP/IP and named pipe service should be enabled here !) Click "application" and you will see the following message:

"The changes made to the connection settings will not take effect until the Database Engine service is restarted ." Click OK.

 

4. Firewall problems: You can add port 1433 to the exception.

 

2, address already in use: jvm_bind: 8080?

Cause: port 8080 is occupied

1. The independent running Tomcat is not closed. the self-installed Tomcat program is set to run automatically upon startup, or before running, close myecplipse or JBuilder, find the Tomcat process in the task manager, and kill it. when Tomcat is disabled illegally, it still exists in the process and still occupies port 8080. therefore, you only need to kill the process. you can solve this problem.

 

2. If other software is installed, Tomcat port is occupied. Use a tool that can view the port to check the port, or change the default port of Tomcat directly. That is

 

3. How can I/O errors occur when receiving the TDS pre-Logon response?

In fact, it works with COM. Microsoft. sqlserver. JDBC. sqlserverexception: Software caused connection abort: Recv failed

It's one thing! It's all about port problems. What's going on here? An error in data sql2005?

An I/O error occurred when receiving the TDS pre-Logon response when connecting to the database in SQL Server 2005. This may be caused by the connection port of your database. The default port of the SQL Server 2005 database is 1433. However, this default port is usually disabled. Many people connect to port 1434, and port 1434 is the UDP port. If you use port 1434 to connect to SQL Server 2005, a conflict will occur. At this time, an I/O error occurs when you receive the TDS pre-Logon response ].

Note: The following method can be used to solve the error only when you use port 1434 to connect to the database and encounter an I/O error when receiving the TDS pre-Logon response. If you use port 1433 to connect to the database, this problem will not occur. If there are other problems, you can also test whether your port 1433 is enabled.

Solution:

Step 1: Test the port

Choose "start"> "Run cmd" and enter "Telnet 127.0.0.1 1433" at the command prompt.

The following problems occur:

Bytes -------------------------------------------------------------------------------------------------------

C: \ Documents ents and Settings \ Administrator> Telnet 127.0.0.1 1433

Connecting to 127.0.0.1... cannot open the connection to the host. in port 1433: Connection Failed

C: \ Documents ents and Settings \ Administrator>

Bytes -------------------------------------------------------------------------------------------------------

The port 1433 is not enabled.

Step 2: open port 1433

Start Menu-> Program-> Microsoft SQL Server 2005-> Configuration tool-> SQL Server peripheral application configurator-> service and connected peripheral application configurator-> datebase engine-> remote connection-> select local connection and remote connection-> select use TCP/IP and named pipes at the same time-> click Application OK-> disconnect SQL Server 2005, reconnect to SQL Server 2005-> stop service-> Start Service-> OK!

Step 3: Test port 1433 again

Repeat the first step. If no problem occurs in the first step, open it!

 

 

4, when myecplise is turned on, a red prompt appears: Unable to update index for central http://repo1.maven.org/maven2/

Solution: first, you needWindow=>Preferences=>MyeclipseEnterpriseWorkbench=>Maven4myeclipse
This is enabledEnableMaven4myeclipseFeaturesTo enable the plug-in.
This wayWindow=>Preferences=>MyeclipseEnterpriseWorkbench=>Maven4myeclipse=>Maven
That's it! Select again!