SQL Error in SCOM 2016 TP5

I did a pretty clean installation and stumbled on the following Alert in SCOM 2016 TP5:

Database connectivity is lost, with details:

The EXECUTE permission was denied on the object ‘sp_help_jobactivity, database ‘msdn’, schema ‘dbo’

The following SQL did the fix: (Data Writer Account)

use msdb
go
Grant Execute ON OBJECT::[dbo].[sp_help_jobactivity] To [HQ\OMDWWrite]

See you


Comments (3):

  1. Stefan says:

    Yepp, ran into the same alert when installing TP5.
    Your SQL-fix cleared it :-)

  2. […] database ‘msdn’, schema ‘dbo’“ Schnell fand ich mit diesem diesen Blogpost einen Lösungsansatz und setze die Rechte für den Account „NT AUTHORITYSYSTEM“ (SCOM läuft […]

Leave a Reply