SQL 2005 Cannot Save Maintenance Plan

PROBLEM:

·         You are trying to create or edit a maintenance plan in SQL Server 2005 Server Management Studio and are presented with an error “No description found” when you save or open the plan.

·         You are running SBS2003 / SBS2003 R2 / Server 2003 (most editions) with SQL Server 2005 (any edition) installed.

·         Installing SQL 2005 Service Pack 1 does not solve the error.

SOLUTION THAT WORKED FOR ME:

The issue occurs when another program installed on the server changes certain settings.

Close Server Management Studio (you will lose any changes currently made).

Open a command prompt and type the following commands in order (press ENTER after each command):

regsvr32 msxml3.dll

regsvr32 msxml6.dll

Open Server Management Studio again and try to edit or create a new plan again.

This solution was found here http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=243850

Instead of the above dll’s you could also try the following commands if the above does not work:

regsvr32 C:WINDOWSsystem32msxml.dll

regsvr32 C:WINDOWSsystem32msxml3.dll

This solution was found here http://sqllearnings.blogspot.com/2009/02/no-description-found-error-when.html and suggests you reboot your computer after these specific commands, however the Microsoft article referenced below does not mention this requirement.

OTHER POSSIBLE SOLUTIONS:

·         If you have installed Visio 2003 after SQL2005, try http://support.microsoft.com/kb/873460/

·         An alternate version of the above is here http://www.sqlservercentral.com/Forums/Topic294631-149-1.aspx#bm294778

·         If none of these work, call Microsoft Support, as it could be some hitherto unknown thing that will commit you to an insane asylum if you try to figure it out alone.