DBLearner


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

Thanks,

DBLearner




Re: SQL Server Agent - start up account.

Caddre


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

http://msdn2.microsoft.com/en-us/library/ms191543.aspx

Madhu