Hi all,

Please let me know what specific privileges an user account needs to be used as a LOG ON AS account for SQL Server Agent in SQL Server 2005.

Does the account needs to me in the domain administrator group



Re: SQL Server Agent - start up account.


Yep if you plan to use Replication and data automation which converts the Agent to a robot that moves data from one part of the Enterprise to another. You need to spend time with it because you can use proxy accounts for the automations. Run a search for Replication permissions requirements, Maintenance plans Agent dependency and Agent proxy accounts in SQL Server BOL. Hope this helps.

Re: SQL Server Agent - start up account.

Madhu K Nair

refer this

Selecting an Account for the SQL Server Agent Service