loads of useful information, examples and tutorials pertaining to web development utilizing asp.net, c#, vb, css, xhtml, javascript, sql, xml, ajax and everything else...

 

C-Sharpener.com - Programming is Easy!  Learn Asp.Net & C# in just days, Guaranteed!

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

by naspinski 1/22/2008 10:44:00 AM

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.

Currently rated 5.0 by 3 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

sql

Related posts

Add comment

Name*
E-mail* (Gravatar)
Website
Country   Country flag

Comment* [b][/b] - [i][/i] - [u][/u]- [quote][/quote]




Live preview

12/1/2008 3:51:16 PM