Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI)
Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.Initialize(MaintenancePlanData planData)
at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintView.LoadMaintenancePlan(String connectionString, IManagedConnection connection, String objectUrn)
at Microsoft.DataTransformationServices.VsIntegration.DtsDesignerService.OpenDesigner(String connectionString, Object connection, String objectUrn)
at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke()
I had the same issue in around 3 production SQL 2005 servers which already had SP2. I tried reinstalling Management studio. Reinstalled Inegration services and both didnt work.Solution:
So as a last resort I reinstalled SP2. Note as it was production I didnt reinstall SP2 on "Database Engine" and "Reporing services" and also "support files" were unchecked.
The above error message shows up whenever there is a difference in the version of Database engine and SQL Client Tools. So if you ever get the above error message, there is no need to uninstall or reinstall Client tools or any other components. Simply make sure that the version of both the Database engine and the SQL client tools is same, and that would take care of the problem.
Comments
Post a Comment