JDBC Connection Error when trying to connect to SQL Server Database
When trying to connect to the SQL Server database, we are getting the following error:
Connection String: //<ServerName>;databaseName=JTS;user=xxxxxxxx;password=xxxxxxxx;instanceName=<InstanceName>
CRJAZ1365I The server is attempting to connect to the following database: "//<ServerName>:1433;databaseName=jts;user=xxxxxxxx;password=xxxxxxxx;instanceName=<InstanceName>"
2019-11-13 06:13:04,800 [ Default Executor-thread-50] ERROR com.ibm.team.repository - CRJAZ2654E The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 08S01, SQLCODE: 0). Verify the connection settings in your teamserver.properties file. See the Jazz Team Server log for more information.
com.microsoft.sqlserver.jdbc.SQLServerException: 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:1933fb92-5289-49e7-8e5a-af769e4c25bd".
What could the problem here be?
Thanks in advance.
One answer
Hi Martina,
It seems you are trying to connect to MSSQL using SSL encrypted port. Did you add certificate used by MSSQL DB to the WebShere Libery keystore.
Based on what you provided this is potential issue.
Comments
Hi Bartosz
Thanks for the quick reply. Encryption is not enabled on SQL Server Side so no certificate is required.
Martina,
What is SQL version, what is port number for SQL, do you use firewall between machines or is it the same machine.
Can you ping the database from JTS server or even can you execute telnet db_host db_port and check if you can get access?
It's a SQL Server 2014 (12.0.6329.1)
Telnet is working as well as ping. Firewall is configured to allow port 1433.
Martina,
If you are using Jazz 6.0.6 or 6.0.6.1 please check if you have JDBC driver for Java8 under sqlserver directory in <JazzTeamServer>/server.