Post reply

NT AUTHORITY/SYSTEM

  • November 2, 2004 at 1:11 pm

    #84083

    I am running some DB maintenance plans and they are failing and I am getting a error message in sql server error log "Login failed for USER NT AUTHORITY/SYSTEM"

    What is or who is NT AUTHORITY/SYSTEM?

    Taj


    Tajammal Butt

  • November 2, 2004 at 5:14 pm

    #528696

    Most likely your sql server agent is running under a (Local System) account as opposed to a domain account.  You get the same problem if you have a Windows Service configured under local and it tries to connect to SQL Server.

    Remember this when a developer tells you it will just be temporary. Temporary = Permanent.

  • November 3, 2004 at 8:07 am

    #528785

    Just to add to bhunter1, the only time you'd get that would be if you removed Builtin\Administrators from the System Administrators server role. We, in fact, do delete the Builtin\Administrators logins, but carefully - only after making sure we can log in with sa along with adding the NT account that both SQL Server and SQL Agent services run under to the server (w/ System Administrator).

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply