While trying to create some maintenance plans on MsSql server 2005 (default installation) with SP2 installed I have received this error message:
'Agent XPs' component is turned off as part of the security configuration for this server.
While trying different solutions from Microsoft, MSDN and different forums I have found one that worked for me. Open new query window, copy code below and hit F5 for executing. After this you can create plans.
sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Agent XPs', 1; GO RECONFIGURE GO
If you don't already have a Dropbox account then you can create it by clicking on my affiliate link. You will receive 2GB free account + 250 MB extra and I will receive 250 MB as well. Win-Win :-)








