Home Forums SQL Server 2005 Administering Login failed for user 'NT AUTHORITY\SYSTEM', Very straing RE: Login failed for user 'NT AUTHORITY\SYSTEM', Very straing

  • andersson_par (5/3/2013)


    SCOM it is!

    To make this work use a service account to run the scom agent service with this:

    Member of "Performance Monitor Users" local group

    Member of "Event Log Readers" local group if OS is Windows 2008 or Windows 2008 R2

    Member of "Distributed COM Users" local group if SQL Server is running in a clustered configuration

    Full access to Cluster if SQL Server is running in a clustered configuration

    Permission to Log On Locally

    SQL permission to VIEW ANY DEFINITION

    SQL permission to VIEW SERVER STATE

    SQL permission to login in each database including system databases

    Member of "SQLAgentReaderRole" in msdb database

    Thanks for sharing!