Solved

Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.

Posted on 2009-05-06
2
4,457 Views
Last Modified: 2012-05-06
I have just upgraded to SQL Server 2005 from SQL Server 2000.In Microsoft SQL Server Management Studio, when I click on the SQL Server Agent log, I receive the following error. Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
0
Comment
Question by:iniasoporte
2 Comments
 
LVL 10

Accepted Solution

by:
laneduncan earned 500 total points
ID: 24316579
If you can't enable the Agent through the GUI, something may have gotten messed up elsewhere.  Try the steps listed here:
http://www.rprabhala.com/Dasblogce/blog/CommentView,guid,ee1c2143-5e5a-46de-9685-f096a674121b.aspx
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Creating and Managing Databases with phpMyAdmin in cPanel.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question