Jira Align Enterprise Insights Self-Hosted installation fails with "Only a member of the sysadmin server role can add a job for a different owner with @owner_login_name"

Summary

During the installation of the Enterprise Insights Self-Hosted, the script Install.PS1 fails with the message “Only a member of the sysadmin server role can add a job for a different owner with @owner_login_name"

Environment

Jira Align Self-Hosted

Diagnosis

The script will display the message “Only a member of the sysadmin server role can add a job for a different owner with @owner_login_name"

Cause

The Enterprise Insights DB user account does not have enough permission to add/modify the SQL job for ETL process.

Solution

To check and change the permission:

1. Open the SQL Server Management Studio being used, log into the DB

2. On the Left Panel > Security > Logins: find the user in question > right-click > Properties

3. On the Server Roles tab, mark the sysadmin option

4. Rerun the Install.PS1 script