Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Error connecting to MS SQL database during install

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,

jiradb.png

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

Error connecting to database

Login failed for user 'jiraadmin'. ClientConnectionId:4d9850de-3e03-4696-b08a-dce5775c8f7b

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:

dberr.png

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.

1 answer

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

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.

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

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?

Does this apply as I stated I am using Windows Server 2016 and not Linux?

In any case there is only the 7.2.1 in the lib folder.

Yes, but probably you must search the file under a diferent location:

e.g: C:\Program Files\Atlassian\jira\lib or a similar path.

 

EDIT:
I miss your previos message.

Let's see if someone else have new ideas about what can be happening.
In the meanwhile, I suggest to directly open a support request to the Atlassian Team to discard that this behaviour is caused by a misconfiguration or malfunction.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,375 views 22 32
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you