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

By | 2016-05-23T20:33:58+00:00 May 23rd, 2016|Operations Manager (SCOM)|3 Comments

About the Author:

Kåre Rude Andersen

Microsoft Certified Trainer since 1996, MCSE, TS and ITP in Microsoft Windows, SQL (also Microsoft), Exchange (MS) and Microsoft Operations Manager. Senior Consultant and have recently worked as a consultant at CSC, SAS, ISS, Nokia and Scandlines.

3 Comments

  1. Stefan June 2, 2016 at 16:06 - Reply

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

    • Stefan June 2, 2016 at 16:23 - Reply

      Nah, to quick, the error is there again

  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 Comment