It's all about the answers!

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

×7,462
×6,109
×1,291
×82
×37
×24
×4

question asked: Oct 03, 8:51 a.m.
question was seen: 292 times
last updated: Oct 25, 1:50 a.m.

Related questions

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

0
Shridharan Balasubramanian (11●1●1) | asked Oct 03, 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!

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Daniel Moul (4.9k●13●18) | answered Oct 03, 9:23 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

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.

Comments
Shridharan Balasubramanian commented Oct 04, 12:56 a.m.

I'm using ELM liberty server 7.0.2 SR1

Daniel Moul commented Oct 04, 9:10 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

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 commented Oct 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 commented Oct 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 commented Oct 25, 1:42 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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 commented Oct 25, 1:50 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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 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.