Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rudba
Constraint Violating Yak Guru
415 Posts |
 Posted - 2009-06-16 : 14:38:44
|
| I have SQL Server 2005, I am trying to create new Maintenance Plans but getting error.I enabled the xp_cmdshell on SQL Server 2005 Surface Area configuration.Anybody know how to solve this problem?I got the following error:'Agent XPs' component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online. (ObjectExplorer)------------------------------Program Location: at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke() |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-16 : 14:45:32
|
| http://www.treeratfishing.com/2008/01/15/enabling-agent-xps-on-sql-2005/ |
 |
|
|
rudba
Constraint Violating Yak Guru
415 Posts |
Posted - 2009-06-16 : 14:51:30
|
| Thanks a lot visakh16, now i can able to create maintenance plan. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-16 : 14:53:53
|
| welcome |
|
|
|
|
|
|
Getting Error to create new maintenance plan