nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error connecting to MS SQL database during install

Doug Shy

Installing Jira 8.3.3 on Windows Server 2016. Database is MS SQL 2017 on a different server. After filling out the details on the Database setup page,

when clicking the "Test Connection" button I get the following error:

Error connecting to database

On the SQL server, the error is:

Login failed for user 'jiraadmin'. Reason: An attempt to login using SQL authentication failed. Server is configured for Integrated authentication only. [CLIENT: 10.98.64.43]

This is false. Here's a screenshot:

I CAN logon to the MS SQL Management Studio with that same username and password. I CAN connect successfully from the Jira server using an ODBC connection with the same username and password. This leads me to believe it is a Jira issue.

I tried initially making the jiraadmin user just a user with dbowner role and creating a new jira schema as suggested. In the process of trying things jiraadmin has been elevated up to the dbowner and the using the dbo schema, all with no change in results.

Accepted answers

All comments

Jack Nolddor [Sweet Bananas]

Hello Doug Shy,

You will need to restart the SQL Service once you have changed your authentication mode. Could you tell us if this solve your problem?

Regards

Doug Shy

I probably should have mentioned that I have restarted both servers several times, and that Confluence was just installed in the same server, using the same DB server, and works fine using a SQL account.

Doug Shy

But I just restarted it again anyway, and no change.

Jack Nolddor [Sweet Bananas]

Which jdbc driver version are you using? v6.2.1 or v7.2.1?

This can be found on /opt/atlassian/jira/lib (supposing you are using the default path on a linux server) and looking for a file calle mssql-jdbc-<VERSION>.jre8.jar

If you are using the v6.2.1 do you mind to backup this file, remove it and try to use the v7.2.1 instead?

Thomas Theobald

Did this problem ever get solved?

Alistair Stewart

I'd like to know too, I'm getting the exact same problem. SQL authentication works fine connecting as the user via ODBC, just not Jira.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server