Upgrade: Database installer failed - Sysadmin role required to update or delete jobs

Symptom:

Database upgrade fails with log file showing below error:

Error SQL72014: .Net SqlClient Data Provider: Msg 14525, Level 16, State 1, Procedure sp_delete_job, Line 103 Only members of sysadmin role are allowed to update or delete jobs owned by a different login​

 

Resolution:

The scheduled jobs installed by AirWatch were created using an account with sysadmin privileges. To modify or remove these jobs the account being uses to connect to the AirWatch database just have sysadmin privileges. Run the Database installer again and connect to the database with an account that has sysadmin access.

Have more questions? Submit a request

0 Comments

Article is closed for comments.