Maintenance Plan Creation Failure in Wizard

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.JobBaseCollection' 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 maintenanc
e
plan in SQL 2005:
Class not registered (Exception from HRESULT: 0x80040154
(REGDB_E_CLASSNOTREG)) (System.Windows.Forms)
at System.Windows.Forms.UnsafeNativeMethods.CoCreateInstance(Guid& clsid,
Object punkOuter, Int32 context, Guid& iid)
at System.Windows.Forms.AxHost.CreateWithoutLicense(Guid clsid)
at System.Windows.Forms.AxHost.CreateWithLicense(String license, Guid
clsid)
at System.Windows.Forms.AxHost.CreateInstanceCore(Guid 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.CreateDdsView(Control
parentControl)
at
Microsoft.DataTransformationServices.Design.DtsComponentDiagram.CreateDdsVie
w(Control parentControl)
at
Microsoft.DataWarehouse.Controls.DdsDiagramHostControl.set_ComponentDiagram(
ComponentDiagram value)
at
Microsoft.DataTransformationServices.Design.DbMaintSequenceDesigner.get_DbMa
intDiagramHost()
at
Microsoft.DataTransformationServices.Design.DbMaintSequenceDesigner.Microsof
t.DataTransformationServices.Design.IDbMaintSequenceDesigner.get_DiagramHost
()
at
Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.ge
t_SelectedSubPlanDesignerHost()
at
Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.Se
lectSubPlan()
at
Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.gr
id_SelectionChanged(Object sender, SelectionChangedEventArgs args)
at
Microsoft.SqlServer.Management.UI.Grid.GridControl.OnSelectionChanged(BlockO
fCellsCollection selectedCells)
at
Microsoft.SqlServer.Management.UI.Grid.GridControl.SelectedCellsInternal(Blo
ckOfCellsCollection col, Boolean bSet)
at
Microsoft.SqlServer.Management.UI.Grid.GridControl.set_SelectedCells(BlockOf
CellsCollection value)
at
Microsoft.SqlServer.Management.UI.Grid.DlgGridControl.SetSelectedCellInt(Int
32 rowIndex, Int32 colIndex)
at
Microsoft.SqlServer.Management.UI.Grid.DlgGridControl.SetSelectedCell(Int32
rowIndex, Int32 colIndex)
at
Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.Po
pulateGrid()
at
Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.In
itialize(MaintenancePlanData planData)
at
Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintView.LoadMaintenan
cePlan(String connectionString, IManagedConnection connection, String object
Urn)
at
Microsoft.DataTransformationServices.VsIntegration.DtsDesignerService.OpenDe
signer(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.JobBaseCollection' 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.
>

Maintenance Plan Creation Failure in Wizard

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.
>