It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×6,031
×1,693

question asked: Nov 13 '19, 5:12 a.m.
question was seen: 2,572 times
last updated: Nov 14 '19, 5:45 a.m.

Related questions

JDBC Connection Error when trying to connect to SQL Server Database

0
Martina Sordakis (11●1) | asked Nov 13 '19, 5:12 a.m.

 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

Most liked answers ↑|Newest answers|Oldest answers

2
permanent link
Bartosz Chrabski (3.4k●2●29●49) | answered Nov 13 '19, 5:34 a.m.

 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
Martina Sordakis commented Nov 13 '19, 6:48 a.m.

 Hi Bartosz



Thanks for the quick reply. Encryption is not enabled on SQL Server Side so no certificate is required. 
 


Bartosz Chrabski commented Nov 13 '19, 8:49 a.m.

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? 

Martina Sordakis commented Nov 14 '19, 3:09 a.m.

It's a SQL Server 2014 (12.0.6329.1)

Telnet is working as well as ping. Firewall is configured to allow port 1433.

Bartosz Chrabski commented Nov 14 '19, 5:45 a.m.

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.

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.