Cannot Stop SQL Server Agent

• beath

  SSCrazy

  Points: 2939

  More actions

  May 9, 2003 at 9:29 am

  #105709

  I have a central SQL 7 server that I use to administer other SQL 7 servers around the office using EM. However on some of them I can't seem to stop the SQL Server Agent. All servers are registered with the sa user but some of them give me Access Denied when I try to stop the service. Is this anything to do with the user account the agent is running under?

  Thanks

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  May 9, 2003 at 9:52 am

  #456685

  Those servers may be in different domain than others that you have permission to start/stop services.

  You can remote manage those serevers to start/stop services but you need to be local administrator in those machines.

• beath

  SSCrazy

  Points: 2939

  More actions

  May 9, 2003 at 10:00 am

  #456687

  I wasn't local admin on those particular servers - all sorted now.

  Thanks