Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2621
  • Last Modified:

MS SQL 2005 - Error in creating/editing maintenance plans

Hello,

Windows 2003 64bit - MS SQL 2005 64bit
SQL Integration Services are installed !


When creating or editing a maintenance plan I get error :

Cannot Show the editor for this task.
Additional information : Exception from HRESULT : 0xc0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

FULL TEXT :
===================================

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(DbMaintenanceBackupTask task)
   at Microsoft.SqlServer.Management.DatabaseMaintenance.DBMaintTaskBackupForm..ctor(TaskHost taskHost, IServiceProvider provider)
   at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintTaskBackupUI.GetView()
   at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.GetTaskEditor()

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

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

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

   at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPropertiesProvider90.get_Properties()
   at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()

Can somebody help me ?

Thank you

Hans


0
o-tvw-ee
Asked:
o-tvw-ee
1 Solution
 
IT-SchubertzCommented:
Hi,

are you at the machine or are you remote?
Some basic things to check for:

http://msdn2.microsoft.com/en-us/library/ms141198.aspx 

http://msdn2.microsoft.com/en-us/library/ms137861(SQL.90).aspx 


hth

Andy
0
 
o-tvw-eeAuthor Commented:
Hello Andy,

I remotely manage the server through remote desktop with console option.
There is no windows firewall active on the server (disabled service)

Tnx
0
 
IT-SchubertzCommented:
Hi,

is RPC enabled?

Andy
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
o-tvw-eeAuthor Commented:
Hello Andy,

the RPC server is enabled.

Hans
0
 
IT-SchubertzCommented:
Hi,

this is strange.
Did you try reinstalling just the management studio?

Andy
0
 
o-tvw-eeAuthor Commented:
Hi,

I reinstalled the whole software and now the problem is solved.
Only god knows what meight have gone wrong during the first installation.

Thank you for your help

I will give you the points for your efford

Regards,
Hans
0
 
blahphishCommented:
just for future reference - this fixed my problem:
%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll"
0
 
ozkuttyCommented:
Thanks Blahphish. This worked for me as well. Much easier than re-installing.
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now