Agent XPs component is turned off
In Microsoft SQL Server Management Studio you get the following errors when trying to create a management plan either through the “Maintenance Plan Wizard” or the “New Maintenance Plan…” on an SQL Server 2008.
Cannot show requested dialog. Additional information: unable to execute requested command. ‘Agent XPs’ component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Agent XPs’ by using sp_configure.
To fix this right click on the server and select “New Query” as shown.
In the query window on the right type the following:
sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘Agent XPs’, 1;
GO
RECONFIGURE
GO
Then click Execute as shown.
Microsoft SQL | Wayne | 
April 22, 2010 6:05 pm
3 Comments
Other Links to this Post
RSS feed for comments on this post. TrackBack URI
By Bill M., June 10, 2010 @ 1:43 am
I had the problem exactly as described, blindly followed the fix instructions, and it worked. Thanks.
By chris m., April 11, 2011 @ 8:43 pm
Thanks. That worked smoothly and resolved the error. Not sure what caused the agent to stop running, but at least the maintenance plans are working and we’re getting backups now. Thanks
By bensode, January 8, 2012 @ 1:16 am
No worky … get syntax errors even when pasting.