Upgrade: Database Installer Failed - The SELECT permission was denied on the object 'sysjobs'

Symptoms:

Database install fails with the following error: "Deployment of Database seems to appears to have failed. Log file will be opened after you select OK."

1.jpg

Database log: 

Error SQL72014: .Net SqlClient Data Provider: Msg 229, Level 14, State 5, Line 16 The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'.

 

Resolution: 

The account used to run the DB installer doesn’t have access to see/touch the sysjobs stored procedure because the account that initially installed AirWatch had higher permissions than necessary. 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.