Windows Authentication with Jira

[Balkis Khouni]

Hello,

I just upgraded a Jira instance from version 7.9.1 to version 7.13.1.

Since version 7.5+, JTDS MSSQL driver is not supported anymore. As a consequence, the database configuration has to change according to This KB.

The problem I am facing is the following:

We are running Jira service on a server that's on a Public domain, and the database on a server that's on a private domain. It is not possible for us to have an SQL domain user run the Jira service and have direct access to the database.

Is there a way to force Jira to follow the provided username and password that are on dbconfig.xml?  Because currently it tries to log in to the DB with the user that starts the Jira service.

Thank you!

Balkis

[Andy Heinzer · Accepted solution]

It's possible, but it is dependent on MS SQL being in mixed authentication mode.  When the SQL Server is configured only to use Windows Authentication mode, it is not possible for an application like Jira to use the login credentials set in the dbconfig.xml file.

That is by design in Microsoft SQL.   If your SQL server is only using Windows Authentication, then you will need to start the Jira Service using a Domain windows account that has both admin access to that Windows machine, and SQL access to that database in order to be able to have the permissions needed to make this work.

[Balkis Khouni]

Hi Andrew,

Yes we just realised we should just change the database authentication mode to SQL authentication. 

Thank you for your answer!