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"
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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
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:
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
On the Server Roles tab, mark the sysadmin option
Rerun the Install.PS1 script
Was this helpful?