December 03, 2011

TCP IP connection Failed Address already in use

The TCP/IP connection to the host , port 1433 has failed. Error: "Address already in use: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port

Type: SQL server exception when used with ms jdbc drivers

Drivers: JDBC (sqljdbc4.jar, sqljdbc.jar) from microsoft

Solutions:
Solution 1:

In my problem i was not using JDBC pool, in configuration when i add the node for pool. after restarting the application it started working for me.

In my case error occurred in Tridion CMS.

Solution 2:
Go to: SQL Server Configuration Manager -> Protocols for SQL SQLEXPRESS,
then select Properties of TCP/IP. 
In the tab IP Addresses, set the TCPPort in section IPAll to 1433.