"'Agent XPs' component is turned off as part of the security configuration for this server." error while creating maintenance plans on MsSQL server 2005

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 :-)

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks
  • PDF
This entry was posted in Tips and tricks and tagged , , , , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>