SQL Server Maintenance plan not opening
You may get below error when you try to open any SQL Server Maintenance Plan: -
TITLE: Microsoft SQL Server Management Studio
‘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. For more information about enabling ‘Agent XPs’, see “Surface Area Configuration” in SQL Server Books Online. (ObjectExplorer)
Issue: -
Its possible that some one have disabled Agent XPs component on your server.
Resolution: -
Run below sql query to re-enable Agent XPs and then try to open maintenance plan again. It will work.
sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Agent XPs', 1; GO RECONFIGURE GO
No comments yet
