Oct
12
0

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

Author andy18    Category SQL-related     Tags

I was trying to setup a SQL backup maintenance on a SQL 2005 today notice the it does not allow me to do so. At the SQL Management Studio, it shows that the “Agent XPs disabled” at the SQL Server Agent. It looks like this has been miss out to enable during the initial installation. In order to enable this, you will need to run the following T-SQL

use master
go
sp_configure ’show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘Agent XPs’, 1;
go
RECONFIGURE
GO

Alright, everything is set and the message went away. However, it still does not allow me to start the SQL Agent services. The event log captured the following during the service startup:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17750
Date: 10/12/2007
Time: 1:37:19 AM
User: NT AUTHORITY\SYSTEM
Computer: IDOCM
Description:
Could not load the DLL xplog70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I try lookup on the SQL installation directory binn folder and to my surprise the xplog70.dll is not there. I copied the dll from another SQL installation server and voila, the SQL Agent services has been started!

Post comment