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
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:
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.
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?
Yes, but probably you must search the file under a diferent location:
e.g: C:\Program Files\Atlassian\jira\lib or a similar path.
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.
Fantastic write up there there, thank you.
Now I move on to my next problem, installing a new Jira install using SQL integrated security, because you can't out of the box and credentials in conf files are bad mmkay.
Another you must be kidding Jira moment I will be having fun with!
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
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