Maintenance Plan Error

Windows 20003 Enterprise server

SQL 2005 Standard with SP2

When I try and create a maintenance plan either via the wizard or just create new, I get the following error. Can anyone help please. thanks

===================================

Cannot show requested dialog.

===================================

Unable to execute requested command.

Program Location:

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

===================================

Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.Management.MaintenancePlanWizard)

Program Location:

at Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm..ctor(XmlDocument doc, IServiceProvider serviceProvider)

Hello Theon,

This sounds like your client tools are older than SP2. The SP2 version of the Microsoft.SqlServer.MaintenancePlanTasks.dll assembly removed the function mentioned in the error message, so that's why the function cannot be found.. Can you check what version of Management Studio you're running, and see if its older than SP2? Also are you running Management Studio on the sql server machine, or connecting to it remotely?

James

|||

Here is the version

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790

I am connecting on the server

|||Applied sp2 and all is well thanks
|||

Glad to help, Theon.

James