Fixing Scheduled Maintenance Mode in SCOM 2016

In all of the SCOM installations I’ve done or seen recently, I see the issue with the scheduled maintenance mode not loading and producing the following error:

“The EXECUTE permission was denied on the object ‘sp_help_jobactivity’, database ‘msdb’, schema ‘dbo’.
The data access service account might not have the required permissions”

This is due to the data access account not being given the correct permissions at install. So as standard now i have started adding these as soon as the install is

completed and the account is showing in the SQL logins.

You can do this by going to SQL Management studio, expand Security – Logins, and select the account you used for the data access service account.
In the accounts properties select User Mapping, and check the box next to the MSDB database.

Grant the following permissions to the MSDB database:
– SQLAgentOperatorRole
– SQLAgentReaderRole
– SQLAgentUserRole

Once this has been done scheduled maintenance mode will work immediately.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.