Click here to Skip to main content
12,890,211 members (44,813 online)
Click here to Skip to main content
Add your own
alternative version


Posted 23 Sep 2011

SQLAgent XPs disabled after repair of MSSQL 2008 R2

, 23 Sep 2011 CPOL
Rate this:
Please Sign up or sign in to vote.
How to resolve this.

After running a repair on MSSQL 2008 R2 you may find that the SQLAgent does not start up and indicates "Agent XPs Disabled" in SSMS. The following steps can be used to try and resolve this issue:

Configure XPs Option

sp_configure 'show advanced options',1
reconfigure with override
sp_configure 'Agent XPs',1
reconfigure with override
sp_configure 'show advanced options',0
reconfigure with override

Security Groups

Ensure that the startup account of SQLAgent is part of the sysadmin group. Ensure that the SQLAgent startup account is a member of the local Windows group on the server called SQLServerSQLAgentUser$ServerName$InstanceName.

After our repair, all the above steps were required. Step 3 wasn't found in any article online, but only by going through all the options available.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Jan Steyn
Web Developer CyberNerd
South Africa South Africa
No Biography provided

You may also be interested in...

Comments and Discussions

-- There are no messages in this forum --
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170424.1 | Last Updated 23 Sep 2011
Article Copyright 2011 by Jan Steyn
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid