asked on

SQL Server Agent Won't Start - Agent XP Disabled and Error in Event Log

Hello all. I am not sure if someone disabled something but SQL Server agent wont start and says it was started and stopped. I looked in the event log and I am seeing the following:

SQLServerAgent could not be started (reason: Failed to load any subsystems. Check errorlog for details.).

Then I see another set of errors:
Could not load the DLL xplog70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

DantheDBA

The first place I would start would be by checking the SQL Server Configuration to verify that Agent XP's are enabled.

To do this run 'exec sp_configure' without any parameters, it will list a 1 under run value for Agent XPs if it is enabled.

If that is not the issue then you may be missing the file referenced in the error log. If it is missing that particular dll you may try copying it from another location (probobly not recommended by Microsoft), or re-installing.

Unfortunately this does not sound like an easily remedied situation.

ASKER CERTIFIED SOLUTION

rush22

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

JohnJMA

I am experiencing the same problem with SQL Agent XPs running. I run the sp_configure 'Agent XPs', 1; as above but then when I go to start the SQL Agent it says that it started and stopped. I understand I need SQL Agent running so that the backup job I set up under the Management Wizard will run unattended.
Any other suggestions on how to keep the SQL Agent running? I am running MS SQL under SBS 2005.
Thanks,

rush22

I'd check the event log to see if you have any access violations or if any of the dependent services are not running.