May 29, 2008 at 7:34 am
Installed SQL 2005 and I don't see the Maintenance Plan items listed under Management. Hopefully a simple configuration item but I can't seem to find where to enable it. Any thoughts?
May 29, 2008 at 8:02 am
Excerpt from BOL:
You must be a member of the sysadmin role to create and manage maintenance plans, and to view them in Object Explorer. The SQL Server Agent node in Object Explorer is only displayed for members of the sysadmin fixed server role, SQLAgentReaderRole, SQLAgentUserRole, or SQLAgentOperatorRole fixed database roles.
--Ramesh
May 29, 2008 at 8:19 am
user has sysadmin role granted and the menu item is still not visable.
May 29, 2008 at 8:53 am
What edition of SQL Server do you have?
Try enabling OLE Automation in Surface Area Configuration Manager.
--Ramesh
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply