Tuesday, October 11, 2011

MS SQL Server 2005 Class Not Registered error when trying to save/create a Maintenance Plan

     I have had this problem before with other services in SQL Server. I don't understand how Microsoft can miss such things. But currently I could not create or save a maintenance plan on SQL Server. I tried using the wizard and tried making it from scratch. Neither method worked but only by trying to build a plan from scratch was I able to get some usable information. SQL Server responded with Class Not Registered. You know those messages contain so much information. What class was it talking about. I installed everything when installing SQL Server what else could there be? I searched for some time on the web and came across a posting from a Randy Wen:
Registering these 2 DLLs should fix your problem.

regsvr32 msxml6.dll
regsvr32 msxml3.dll

Randy

Thank you Randy.