When trying to create a maintenance plan in MS SQL 2005 using the
wizard I get the following error
TITLE: Maintenance Plan Wizard Progress
Create maintenance plan failed.
ADDITIONAL INFORMATION:
Could not load type
'Microsoft.SqlServer.Management.Smo.Agent.JobBaseC ollection' from
assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91'.
(Microsoft.SqlServer.MaintenancePlanTasks)
BUTTONS:
OK
This seems like something did not install correctly on my server or
something. Any ideas are greatly appreciated.
I'm getting the following error when trying to modify an existing maintenance
plan in SQL 2005:
Class not registered (Exception from HRESULT: 0x80040154
(REGDB_E_CLASSNOTREG)) (System.Windows.Forms)
at System.Windows.Forms.UnsafeNativeMethods.CoCreateI nstance(Guid& clsid,
Object punkOuter, Int32 context, Guid& iid)
at System.Windows.Forms.AxHost.CreateWithoutLicense(G uid clsid)
at System.Windows.Forms.AxHost.CreateWithLicense(Stri ng license, Guid
clsid)
at System.Windows.Forms.AxHost.CreateInstanceCore(Gui d clsid)
at System.Windows.Forms.AxHost.CreateInstance()
at System.Windows.Forms.AxHost.GetOcxCreate()
at System.Windows.Forms.AxHost.TransitionUpTo(Int32 state)
at System.Windows.Forms.AxHost.CreateHandle()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at Microsoft.DataWarehouse.Design.ComponentDiagram.Cr eateDdsView(Control
parentControl)
at
Microsoft.DataTransformationServices.Design.DtsCom ponentDiagram.CreateDdsView(Control parentControl)
at
Microsoft.DataWarehouse.Controls.DdsDiagramHostCon trol.set_ComponentDiagram(ComponentDiagram value)
at
Microsoft.DataTransformationServices.Design.DbMain tSequenceDesigner.get_DbMaintDiagramHost()
at
Microsoft.DataTransformationServices.Design.DbMain tSequenceDesigner.Microsoft.DataTransformationServ ices.Design.IDbMaintSequenceDesigner.get_DiagramHo st()
at
Microsoft.SqlServer.Management.DatabaseMaintenance .DbMaintDiagramHostCtrl.get_SelectedSubPlanDesigne rHost()
at
Microsoft.SqlServer.Management.DatabaseMaintenance .DbMaintDiagramHostCtrl.SelectSubPlan()
at
Microsoft.SqlServer.Management.DatabaseMaintenance .DbMaintDiagramHostCtrl.grid_SelectionChanged(Obje ct sender, SelectionChangedEventArgs args)
at
Microsoft.SqlServer.Management.UI.Grid.GridControl .OnSelectionChanged(BlockOfCellsCollection selectedCells)
at
Microsoft.SqlServer.Management.UI.Grid.GridControl .SelectedCellsInternal(BlockOfCellsCollection col, Boolean bSet)
at
Microsoft.SqlServer.Management.UI.Grid.GridControl .set_SelectedCells(BlockOfCellsCollection value)
at
Microsoft.SqlServer.Management.UI.Grid.DlgGridCont rol.SetSelectedCellInt(Int32 rowIndex, Int32 colIndex)
at
Microsoft.SqlServer.Management.UI.Grid.DlgGridCont rol.SetSelectedCell(Int32
rowIndex, Int32 colIndex)
at
Microsoft.SqlServer.Management.DatabaseMaintenance .DbMaintDiagramHostCtrl.PopulateGrid()
at
Microsoft.SqlServer.Management.DatabaseMaintenance .DbMaintDiagramHostCtrl.Initialize(MaintenancePlan Data 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()
"pyrahna" wrote:
> When trying to create a maintenance plan in MS SQL 2005 using the
> wizard I get the following error
> TITLE: Maintenance Plan Wizard Progress
> --
> Create maintenance plan failed.
> --
> ADDITIONAL INFORMATION:
> Could not load type
> 'Microsoft.SqlServer.Management.Smo.Agent.JobBaseC ollection' from
> assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral,
> PublicKeyToken=89845dcd8080cc91'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> --
> BUTTONS:
> OK
> --
> This seems like something did not install correctly on my server or
> something. Any ideas are greatly appreciated.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment