Results 1 to 2 of 2

Thread: SQL Server Agent

  1. #1
    Join Date
    Sep 2002
    Posts
    51

    SQL Server Agent

    I am running 3 instances of SQL2000 SP3a on a windows 2000 server. Over the weekend, the server was restarted due to security patches being applied. All 3 instances are setup the same (Automatically start SQL Server Agent when restarting server). The 2 named instances started the agent fine but the default instance did not. There are no errors in the log. When I started it manually this morning, it started fine with no errors. Does anyone have any idea why the agent would not have started automatically?

    Thanks,
    Ken

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    Check the dependency of SQL Agent service in Control Panel - Services to make sure MSSQLServer is listed as dependent service.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •