IBM Support

General checks that could be done upon seeing a SQL DB connection failure with Protocol errors.

Troubleshooting


Problem

During JTS setup from web UI, on the Database Configuration page, the Connection to the SQL Server Database fails with the following error message:

The server was unable to connect to the database because the database connection settings are invalid or the database is unreachable(SQLSTATE: 08S01, SQLCODE: 0). Verify the connection settings in your teamserver.properties file. ID CRJAZ2654E.

For the time of error on web UI, the console.log shows an SSL-related error.

Error in the console.log:

Caused by: java.io.IOException: CRLQE0424E An error occurred instantiating database, Cannot create PoolableConnectionFactory (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:942341f6-407b-48e2-94b8-3b8d26f21576".).





Symptom


Document Location

Worldwide


[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSYMRC","label":"Rational Collaborative Lifecycle Management"},"ARM Category":[{"code":"a8m0z000000CbQvAAK","label":"Jazz Team Server-\u003EDatabase-\u003ESQL Server"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

To view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
Rational Collaborative Lifecycle Management

Component:
Jazz Team Server->Database->SQL Server

Software version:
All Versions

Document number:
6556764

Modified date:
25 January 2023

UID

ibm16556764

Manage My Notification Subscriptions