Mike Shellenberger's blog

Navigating the Digital Frontier: End-User Tech Insights

SQL Server Management Studio–Error on Saving Maintenance Plan

Today I attempted to modify the maintenance plan “User Databases – Weekly Backup” on a SQL 2005 SP3 server and received the following error message: “Error loading type library/DLL.‘

SQL_MaintenancePlanErrorOnSave

The fix for this is to open a command line and run the following commands:

regsvr32 msxml6.dll

regsvr32 msxml3.dll

I couldn’t seem to locate a reason why re-registering these DLL files would be necessary.  After registering the DLL’s and making my changes to the maintenance plan everything saved properly.

Published by

2 responses to “SQL Server Management Studio–Error on Saving Maintenance Plan”

  1. Had the same issue on a SQL 2005 x64 Server. Reregistered
    both 32 and 64 bit versions of mentioned files. Rebooted server
    afterwards. Tested – problem fixed. Thanks for the post

  2. Same issue here, XP 32bit version. Appreciate the post!!

Leave a reply to Gart Cancel reply