Jira Align Enterprise Insights Self-Hosted SQL Server Agent not running
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?