March 3, 2009 at 1:54 am
Hello Everybody,
When i am trying to access maintenance plan in SQL Server 2005, I am getting the following error message
"Agent Xp component is turned off as part of the security configuration for this server. A system administrator can enable the use of agent XP's by using sp_configure. For more information about enabling Agent XP's see surface area configuration in SQL Server Books onlie..."
and also i am not able to access the existing maintenance plans also..getting the same error.
Please help....
Thank you
Ansar
March 3, 2009 at 5:09 am
Hi Ansar,
The error message that you got during install is related to the XPs used by SQL Server Agent. You can turn it on by issuing the following commands.
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO
After this you should be able to access the Maintenance plans.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
March 3, 2009 at 7:09 am
ansar.vma (3/3/2009)
Hello Everybody,When i am trying to access maintenance plan in SQL Server 2005, I am getting the following error message
"Agent Xp component is turned off as part of the security configuration for this server. A system administrator can enable the use of agent XP's by using sp_configure. For more information about enabling Agent XP's see surface area configuration in SQL Server Books onlie..."
and also i am not able to access the existing maintenance plans also..getting the same error.
Please help....
Thank you
Ansar
What permissions have you got against the server? If you have sysadmin you can enable SQL Serveagent service.
March 3, 2009 at 11:44 pm
Thanks Adiga......My problem solved..Now i can access maintenance plan...
Thank you
Ansar
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply