• John Dennis (6/2/2008)


    As ALZDBA points out--It is better to create a windows account for the service to run under than NT Authority\SYSTEM. Granting permission to NT Authority\SYSTEM gives "any" service or application, running under that context, the same rights to the SQL Server and there is even less tracability than BUILTIN\Administrators.

    Depending on the 3rd party backup software, though, that may not be a supported configuration. We've hit that wall ourselves. The local SYSTEM does have some implicit rights that even the local Administrators group on the server doesn't.

    K. Brian Kelley
    @kbriankelley