If your Jira Data Center instance is running with Microsoft SQL Server database that is configured to use the Integrated Security e.g. Windows Authentication then an extra configuration step is required for the ActivityTimeline application to run.
➡️ Add the Microsoft SQL Server database driver (mssql-jdbc_auth-XX.XX.X.x64.dll file) into the Windows System32 directory (or any other directory configured in the Windows PATH variable).
For example:
Add mssql-jdbc_auth-12.10.2.x64.dll driver file into C:\Windows\System32 folder.
Here is the table that shows which version of Microsoft SQL Server database driver DLL file to use:
|
ActivityTimeline App version |
MS SQL Server DB Driver version to use |
|---|---|
|
ActivityTimeline v12.4.0 and higher |
mssql-jdbc_auth-12.10.2.x64.dll |
|
ActivityTimeline v12.2.0-v12.3.0 |
mssql-jdbc_auth-10.2.4.x64.dll |
|
ActivityTimeline v12.1.0 and below |
mssql-jdbc_auth-9.2.1.x64.dll |
The driver file can be downloaded from the official Microsoft’s website at: https://learn.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver17#1210
Then open ActivityTimeline Maintenance page at https://<JIRA_HOME_URL>/plugins/servlet/activitytimelineconfig/configuration link
and click “Force Restart“ button at the bottom.
The other possible database driver version incompatibility issue could be related to the default value of “encrypt“ JDBC url parameter before and after v10.2.x.
You may append the current Jira’s JDBC url with the following parameters to trust server certificate:
;encrypt=true;trustServerCertificate=true
Please make sure to restart your Jira DC after that change.
Example url:
jdbc:sqlserver://;serverName=JIRASERVER;portNumber=1433;databaseName=jira-db;encrypt=true;trustServerCertificate=true
In case you are not sure about the changes, please make sure to contact our Support Team