what is the minimum permission for SQL Agent Account

• GRACE_SUNYANG 31474

  Old Hand

  Points: 324

  More actions

  September 27, 2012 at 9:00 pm

  #282313

  I want to use SQL Job to stop one of the service on a remote server, such as 'sc \\server1 stop service1

  I got access denied error, till I gave SQL Agent Account the local administrator right on 'server1'.

  Just don't think this is right to give it administrator right, how should I set this up?

  Thanks.

• Ant-Green

  SSC Guru

  Points: 113566

  More actions

  September 28, 2012 at 1:56 am

  #1543228

  The account needs the rights to stop the service, so this is usually power users or administrators.

  My Google-Fu isn't strong at this time in the morning, so lookup the permissions needed to run NET STOP.