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