We are running SQL 2005 Standard Edition SP3 on a single server. Anytime I attempt to save a maintenance plan, I get a "Class Not Registered" error. I also got this when attempting to edit or delete Maintenance Plans created previously, when this functionality
was working. On this server there is a SQL Server 2000 as the default instance, and the SQL Server 2005 is a named instance.
Looking at other posts everywhere, installing SP2 or SP3 can break the ability to create or edit Maintenance Plans. I can confirm that SSIS is running and that I can now connect to Integration Services in Mainagement Studio (and I was able to delete my old
plans in the Integration Services). There was a problem with this which was cured by manually registering dts.dll and msDtsSrvrUtil.dll in the DTS/Binn folder. I wonder if I need to manually register any more DLLs.
View Complete Post