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.
