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,
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:
Hi I am also facing same issue in tridion CMS, how to add connection pool node in tridion broker ?
Thanks
Nitin
@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>
Post a Comment