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








