dbTalk Databases Forums  

Can't Edit Maintenance Plan

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Can't Edit Maintenance Plan in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Neff
 
Posts: n/a

Default Can't Edit Maintenance Plan - 06-11-2007 , 09:59 AM






I have a clustered installation of SQL Server 2005 running on Windows
2003 with SSIS installed on the cluster.

I'm running SQL Server Management Server on one of the cluster nodes
and I can right click and create a new maintenance plan and drag a
'Back Up Database Task' into the plan. (Using the wizard also works.)

However if I try to open the the Backup item in the plan I get the
following error

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

Cannot show the editor for this task. (Microsoft SQL Server Management
Studio)

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

Exception from HRESULT: 0xC0010014
(Microsoft.SqlServer.DTSRuntimeWrap)

------------------------------
Program Location:

at
Microsoft.SqlServer.Dts.Runtime.ConnectionManager. get_Properties()
at
Microsoft.SqlServer.Management.DatabaseMaintenance .TaskContextUI.InitializeConnectionCombo(String
connectionName)
at
Microsoft.SqlServer.Management.DatabaseMaintenance .DBMaintTaskBackupForm.SetTask(DbMaintenanceBackup Task
task)
at
Microsoft.SqlServer.Management.DatabaseMaintenance .DBMaintTaskBackupForm..ctor(TaskHost
taskHost, IServiceProvider provider)
at
Microsoft.SqlServer.Management.DatabaseMaintenance .DbMaintTaskBackupUI.GetView()
at
Microsoft.DataTransformationServices.Design.DtrTas kDesigner.GetTaskEditor()

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

Exception from HRESULT: 0xC0010014
(Microsoft.SqlServer.DTSRuntimeWrap)

------------------------------
Program Location:

at
Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSProper tiesProvider90.get_Properties()
at
Microsoft.SqlServer.Dts.Runtime.ConnectionManager. get_Properties()

I have searched and found various references to DTSRuntimeWrap,
including many unanswered queries and some which seem to refer to
making sure SSIS is set up on the cluster properly.

I passed on the information at http://msdn2.microsoft.com/en-us/lib...3(SQL.90).aspx
to the installation engineer who tells me that all now been done and
that the servers are up to date with SP2.

Where can I go now? It seems a very specific error message but there
seems to be little information on a resolution.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.