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
Yepp, ran into the same alert when installing TP5.
Your SQL-fix cleared it 🙂
Nah, to quick, the error is there again
[…] 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 […]