SQL Server Agent (Agent XPs disabled)

Question

Post reply

SQL Server Agent (Agent XPs disabled)

rizwan_usa

Old Hand

Points: 334
More actions
November 3, 2007 at 11:35 am

#119254

Hi
I get this message SQL Server Agent (Agent XPs disabled) on SQL Server Agent. When I start this service it runs for 2-3 min and stops automatically. and (Agent XPs disabled) appear again.
Error Log Shows: Message
[355] The mail system failed to initialize; check configuration settings
Please Help!!!!!
I am using SQL Server 2005 and Windows XP sp2

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

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

kmr_jr SSC Journeyman Points: 86 More actions · Answer 1

I am getting the same, but the agent never starts. I've performed the following to get rid of agent xps to no avail:

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic23407.aspx

exec sp_configure 'show advanced options', 1;

GO

RECONFIGURE WITH OVERRIDE;

GO

sp_configure 'allow updates', 0;

GO

RECONFIGURE WITH OVERRIDE;

GO

http://www.sql-server-performance.com/faq/agent_xps_not_running_p1.aspx

use master

go

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Agent XPs', 1;

go

RECONFIGURE

GO

kechot.cool Valued Member Points: 53 More actions · Answer 2

I got the same problem too

I try executing your code and start the SQL Server Agent services manually. It seem that the SQL Server Agent is started. But then after few seconds, the agent is stopped. Here is the error log for the error:

2010-05-07 16:32:28.98 spid53 Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.

2010-05-07 16:32:28.98 spid53 FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'AKMALSQL'.

kmr_jr SSC Journeyman Points: 86 More actions · Answer 3

I believe my fix was to use Sysinternals Process Explorer. I found an "access denied" error to a registry key. Cannot recall which key. I seem to remember it was unusual because no changes were manually made to the system to influence the permissions on the key.