SCOM 2016 – The EXECUTE permission was denied on the object ‘sp_help_jobactivity’, database ‘msdb’, schema ‘dbo’

So I’ve just installed SCOM 2016 in my lab (well actually I’ve probably done it over a dozen times this weekend testing out scripts etc) and my Management Server suddenly popped up this message (after selecting the new Maintenance Schedules in the SCOM Console).

 

Date: 10/15/2016 8:39:18 PM
Application: Operations Manager
Application Version: 7.2.11719.0
Severity: Error
Message:

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

 

So clearly on the last line its telling us that the stored procedure can’t be executed due to inadequate permissions assigned to our DAS account.

Also in the event logs, I saw a flood of the following events, 26319 and 33333.

26319

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

33333

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The solution is to open up the SQL Management Studio and run this statement…just change [culham\s-scomdas] to that of your own DAS account.

 

use msdb
go
Grant Execute ON OBJECT::[dbo].[sp_help_jobactivity] To [culham\s-scomdas]

 

And the problem is solved 🙂

 

 
Comments

Thanks a million,

Worked a treat!

You’re most welcome. Happy it helped.

Thank you. It worked!

My pleasure Michael. Happy to help!

It worked. Thank you.

Leave a Reply