Jira Service Management setup on SQL fails

Eliane Champagne

Hello,

I am trying to complete our Jira Service Management setup for our DEV environment. We already have a working production infrastructure, but we are not able to setup our new dev server. We were already able to set Jira Software and Confluence using the exact same MS SQL server, but Jira Service Management setup process cannot go pass SQL setup. I always get this error in the log file.

“com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "UAT-JiraSD" requested by the login. The login failed. ClientConnectionId:841480d0-0963-454b-ac8f-349dd4a53853”

I’ve tried many different settings in the dbconfig.xml file, but none have worked so far. SQL Server is a Microsoft SQL Server 2016 Developer (64-bit).

Can you help us find a possible cause for this impossibility to connect our DEV?

 

Thank you in advance.

Nic Brough -Adaptavist-

What, exactly, are you entering for the parameters for the connection?

Please, of course, obscure the host name (or ip), username and password - they're not going to be the problem (unless the cat wandered across your keyboard while you weren't looking), it's the rest of the connection stuff we need to look at.