Agent XPs component is turned off as part of the security configuration for this server

If you have installed MSSQL 2005 and tried to set up a maintenance plan, this is likely the error you have encountered

Good thing is that it is extremely simple to remedy.

 

  1. Open Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration
  2. Click 'Surface Area Configuration for Services and Connections'
  3. Click 'SQL Server Agent
  4. Change 'Startup type' to Automatic
  5. Click 'Start'

 

And thats that... problem was is that default, your SQL Server agent is set to run manually, so you would have to start it every time.  Considering you are setting up a maintenance plan, you are going to want this to be automatic.

Comments (3) -

  • one adjustment for those who wouldn't already know..

    Click Apply first then start (for some reason it resets back to manual if you don't).
  • Jim

    You are the MAN buddy!!! Thank you much!

Pingbacks and trackbacks (1)+

Add comment

Loading