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.

Advertisements

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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s