Post reply

Problem starting sql server Agent under local system account

  • July 8, 2004 at 3:36 am

    #83427

    Can we run sql server Agent under local system account when BUILTIN\Administrator doesnot have Sysadmin role?

    Thanks in advance

    --SNT

     

     

  • July 10, 2004 at 2:18 pm

    #514197

    The Agent requires a sysadmin account within SQl Server.

    If BUITLTIN\Administrators isn't sysadmin or doesn't exist the I guess you need to use another account other than system.

    A windows domain level account over the local system account can provide other advantages such as allowing jobs to access shares on other computers. The windows  account can have minimal privileges at windows level as long as it is authenticated as an sa in SQL Server.

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

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