Jira Align Enterprise Insights Self-Hosted SQL Server Agent not running
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
The SQL Server Agent is needed on the Enterprise Insights Self-Hosted, as it will control the ETL job. As default, it comes as not started automatically, so this needs to be changed to be always running (“Start Automatically (delayed)"). In some cases, it will fail to start due to several reasons, and this needs to be addressed.
Environment
Jira Align Self-Hosted
Diagnosis
On the Services Panel (type services.msc on Windows), check if the service SQL Server Agent is present and is running. If it is not, try to start it and see if an error will pop up.
Cause
One possible cause for the SQL Server Agent to not start is to use the wrong permission.
Solution
To check and change the permission:
Open the SQL Server 20xx Configuration Tool > SQL Server Services
Right Click on the SQL Agent > Properties: check the user that it is using (Built-in or Specific Account)
Open the SQL Server Management Studio being used, log into the DB
On the Left Panel > Security > Logins: find the user in question > right-click > Properties (if the user is built-in Local System, on the DB it will correspond to "NT AUTHORITY\SYSTEM”)
On the Server Roles tab, mark the sysadmin option
Return to the SQL Server 20xx Configuration Manager> SQL Server Services try to start the service
Was this helpful?