Hi

[NT AUTHORITY\SYSTEM] should not be sysadmin. You can use a specific account for the SCOM healtservice with just the permissions needed for the specific SCOM managementpack for SQLServer.

There should be...

Alfredo Giotti (4/26/2011)

---

Trigger Code:

BEGIN

SET ANSI_PADDING ON

SET CONCAT_NULL_YIELDS_NULL ON

SET ANSI_WARNINGS ON

DECLARE @LogonTriggerData xml,

@PostTime datetime,

...