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

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.


Nitin said...

Hi I am also facing same issue in tridion CMS, how to add connection pool node in tridion broker ?


Raj said...
This comment has been removed by the author.
Raj said...

@Nitin check pool tag in following
it should be there in Storage tag

<Database Type="sql">
<Pool Type="jdbc" Size="5" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" />
<DataSource Class="">