SQL Server 2005 Error: Exception from Hresult

On a SQL Server 2005 (Standard x64) two-node active-passvie cluster using Windows 2003 (Enterprise x64), we tried to create a backup maintenance plan. Lo and behold! We got the error: “cannot show editor for this task. exception from hresult: 0xc0010014 (microsoft.sqlserver.dtsruntimewrap)”. We tried looking up on Google and came up with a solution recommended many times: install Service Pack 2. But before we went this way, we researched some more, and found the solution.

We are indebted to 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap). They provided a solution which we tried and it worked flawlessly. Just run the following command on the command line (DOS prompt):

regsvr32 "\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTS.dll"

This command should give a successful message upon execution, and when you do get a positive response, the problem with SQL Server should just go away.

7 Responses to SQL Server 2005 Error: Exception from Hresult

  1. Marcos says:

    excelent! problem solved!

  2. babita says:

    this is a simple & excellent solution!!! It worked for me & the problem was resolved.

  3. Jatin Makhij says:

    Problem Solved !!…Thanks

  4. Anonymous says:

    Thank You!!! Thank You!!! Thank You!!!! Carl

  5. Anonymous says:

    Awesome… worked like a charm! Kudos for you!

  6. Anonymous says:

    Thanks, can confirm again, this works!

  7. Anonymous says:

    Fantastic great solution.

%d bloggers like this: