SQL Server 2005 Error: Exception from Hresult
October 29, 2008 7 Comments
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.