Maintance plans corrupted after sp2...

Posted - 03/19/2007 : 09:14:02

---

I installed sp2 on my sql server2005. It failed on database engine service. And i am not able to open existing maintance plans or create new plans.
When i try to open existing plan i am getting the following error:
Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}' failed due to the following error: Interface not registered (Exception from HRESULT: 0x80040155). (Microsoft.SqlServer.ManagedDTS)

Any help appreciated...

Had same issue. What I did was run a manual backup of all my user databases. After that all my maintenance plans were working again (Never had issues with my system dbs tho).

Hope this helps.

Regards

Jonas

|||

Hmm you might wanner have a look there is a patch for SP2 adressing Clean Up issues in regards to Maintenance Plans. Built 9.0.3050 (SP2 is 9.0.42)

Regards

Jonas

|||

Also have a look at the patch for SP2 (built 9.0.3050). It adresses issues in regards to clean up...

Regards

Jonas