Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Jazz Team Server Unable to Connect to SQL Server Database - Error ID CRJAZ1579E & CRJAZ2654E (SQLSTATE: S0001, SQLCODE: 18456)

Questions
Tags
Users
Badges
Shridharan Balasubramanian
(26●3●3●5) Oct 03 '24, 8:51 a.m.

I am facing an issue during the Jazz Team Server (JTS) configuration test where it is unable to connect to the SQL Server database. The error details are as follows:

  • Error ID: CRJAZ1579E
  • Error ID: CRJAZ2654E
  • SQLSTATE: S0001
  • SQLCODE: 18456

I'm using MSSQL Evaluation Edition 2017 and the Microsoft JDBC Driver 4.2 for SQL Server. And then, i connected the driver to SQL Server by creating an environment variable. But diring the setup process , i have faced such error that i mentioned.

Can anyone provide guidance or troubleshooting steps for connecting the JDBC driver with SQL Server by resolving the connection issue? Any specific pointers on what else I should check?

Thanks!

0 votes

1 answer
3,944 views
0 votes

One answer

Permanent link
Daniel Moul
FORUM MODERATOR / JAZZ DEVELOPER (5.0k●13●18) Oct 03 '24, 9:23 a.m.

You didn't mention which version of the ELM products you are working with. Note that we dropped support for Microsoft SQL Server in recent releases. You can use Db2 Standard Edition (it's included with your ELM product license entitlements--see the optional downloads page) or Oracle.

0 votes

Comments
Shridharan Balasubramanian
Oct 04 '24, 12:56 a.m.
I'm using ELM liberty server 7.0.2 SR1

Daniel Moul
FORUM MODERATOR / JAZZ DEVELOPER Oct 04 '24, 9:10 a.m.
7.0.2 is the last release that works with SQL Server, so I expect you can get it to work. Since you will need to do a database migration before upgrading to a later release, I encourage you to think about starting with Db2 or Oracle instead.

Chidambaram L PESIL InfoSol Pvt Ltd
Oct 24 '24, 3:59 a.m.
Hi Daniel, Shridharan is trying to perform a pilot on MS SQL Server to Oracle migration. And we are stuck on bringing the MS SQL configurations for ELM correct. Please share any jazz wiki references to MS SQL server installations for ELM.

Shridharan Balasubramanian
Oct 24 '24, 5:17 a.m.
I'm trying to perform a pilot on MS SQL Server to Oracle migration. And we are stuck on bringing the MS SQL configurations for ELM version 7.0.2 SR1 during setup process . Please share any jazz wiki references to MS SQL server installations for ELM 7.0.2 SR1.

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Oct 25 '24, 1:42 a.m.
I have been successful finding stuff by adding site:jazz.net to my search. e.g. https://www.google.com/search?q=sql+server+site%3Ajazz.net Or search in the documentation e.g.: https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.0.2 typ SQL server in the search bar. E.g. get https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.0.2?topic=database-setting-up-sql-server

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Oct 25 '24, 1:50 a.m.
also search for the error codes. I would assume your connection settings are incorrect. E.g. I found https://jazz.net/forum/questions/286140/getting-error-crjaz2654e-the-server-was-unable-to-connect-to-the-database-because-the-database-connection-settings-are-invalid-or-because-database-is-unreachable-sqlstate-0-while-executing-lockreset-command

showing 5 of 6 show 1 more comments

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,623
× 6,180
× 1,453
× 82
× 37
× 4

Question asked: Oct 03 '24, 8:51 a.m.

Question was seen: 3,944 times

Last updated: Oct 25 '24, 1:50 a.m.

Confirmation Cancel Confirm