locked
Stopped SQL Server Agent (2008) when changed log on account to Domain account RRS feed

  • Question

  • I choose a Domain account for "SQL Server Agent service log on" to can write backup file on other server(file server). After this change agent services stopped and didnt work. I change agent log on account to local system account then service started.

    Now , How can I set Domain account for agent service?

    • Moved by Pawel Marciniak Monday, December 20, 2010 1:27 PM (From:SQL Service Broker)
    Sunday, December 19, 2010 8:02 AM

Answers

  • This question is probably better suited for the database engine forum.

    Perhaps the specified account does not have the proper permissions as described in the Books Online: http://msdn.microsoft.com/en-us/library/ms191543.aspx.  If you make the change using the SQL Server Configuration tool rather than service control manager, the needed rights are assigned automatically.

     

     

     

     


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Marked as answer by WeiLin Qiao Monday, December 27, 2010 6:10 AM
    Sunday, December 19, 2010 5:37 PM
  • @Atervan,

    Please ensure that the SQL Server Agent startup account has sufficient privileges as explained in this article .




    Pradeep Adiga
    Blog: sqldbadiaries.com

    Recent posts on my blog
    • Proposed as answer by Tom Phillips Monday, December 20, 2010 10:09 PM
    • Marked as answer by WeiLin Qiao Monday, December 27, 2010 6:10 AM
    Monday, December 20, 2010 3:18 PM

All replies

  • This question is probably better suited for the database engine forum.

    Perhaps the specified account does not have the proper permissions as described in the Books Online: http://msdn.microsoft.com/en-us/library/ms191543.aspx.  If you make the change using the SQL Server Configuration tool rather than service control manager, the needed rights are assigned automatically.

     

     

     

     


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Marked as answer by WeiLin Qiao Monday, December 27, 2010 6:10 AM
    Sunday, December 19, 2010 5:37 PM
  • @Atervan,

    Please ensure that the SQL Server Agent startup account has sufficient privileges as explained in this article .




    Pradeep Adiga
    Blog: sqldbadiaries.com

    Recent posts on my blog
    • Proposed as answer by Tom Phillips Monday, December 20, 2010 10:09 PM
    • Marked as answer by WeiLin Qiao Monday, December 27, 2010 6:10 AM
    Monday, December 20, 2010 3:18 PM