SCOM Monitoring SQL Server 2008

• Nasferato

  SSC Veteran

  Points: 240

  More actions

  May 25, 2009 at 8:12 am

  #209708

  Greetings

  We are deploying SCOM in our environment to monitor our SQL servers.

  The health Service is running under a local system account.

  In the event log we are getting this error. has anybody been able to resolve this.

  C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 2\50\GetSQL2008LongRunningJobs.vbs(222, 2) Microsoft OLE DB Provider for SQL Server: The EXECUTE permission was denied on the object 'sp_help_jobactivity', database 'msdb', schema 'dbo'.

  Command executed: "C:\Windows\system32\cscript.exe" /nologo "GetSQL2008LongRunningJobs.vbs" S121SQL001041

  Working Directory: C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 2\50\

  One or more workflows were affected by this.

  Workflow name: Microsoft.SQLServer.2008.Agent.LongRunningJobs

  Instance name: SQLSERVERAGENT

  Instance ID: {46FEB661-8BBA-206A-AF20-B19D850D7F96}