Post reply

Cannot Stop SQL Server Agent

  • 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

  • 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.

  • May 9, 2003 at 10:00 am

    #456687

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

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply