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.

3 comments:

Nitin said...

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

Thanks
Nitin

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

<Storage>
<Database Type="sql">
<Pool Type="jdbc" Size="5" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" />
<DataSource Class="com.microsoft.sqlserver.jdbc.SQLServerDataSource">
</DataSource>
</Database>
</Storage>