How to connect SQL Server 2005 throught JDBC to TDV

[Adolfo Isaac Perez]

Hi all,

We are facing an issue with a connection to SQL Server 2005.

We are trying to stablish a connection with SQL Sever 2005 to TDV but we get an error like this:

Unable to connect to data source "/shared/Nitgen" at "[HOST]:[PORT]@[DATABASE]" with the

supplied connection information. [datasrc-3961050]

Unable to connect to data source "/shared/Nitgen" at

"jdbc:sqlserver://[HOST]:[PORT];databaseName=[DATABASE];selectMethod=direct". Make

sure the URL information, user name and password are correct. [datasrc-3961025]

Cause: The driver could not establish a secure connection to SQL Server by using Secure Sockets

Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been

closed. ClientConnectionId:55ef3010-12d9-4433-bc56-69b17f3c8dde". [Log ID: 9adb9a9e-cd13-4181-b8a6-e26508689d3d]

 

 

Theres any restriction on how to connect SQL Server 2005

 

We hope that anyone could help us.

 

Best regards,

[Sharath Chandrika Mummoju]

Hello Amejia,

Refer to the KB articlefor the same issue:

https://support.tibco.com/s/article/SQL-server-connectivity-issue-from-c...

Also, try withsqljdbc42.jarjdbc property authentication =NotSpecified in the JDBC URL pattern or in the JDBC Connection properties.

Regards,

Chandrika