Click here to Skip to main content
Click here to Skip to main content

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
go
reconfigure with override
go
sp_configure 'Agent XPs',1
go
reconfigure with override
go
sp_configure 'show advanced options',0
go
reconfigure with override
go

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.

License

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

Share

About the Author

Jan Steyn
Web Developer
South Africa South Africa
No Biography provided

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web03 | 2.8.141022.2 | Last Updated 23 Sep 2011
Article Copyright 2011 by Jan Steyn
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid