- 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:\WINDOWS\system32\msxml.dll
regsvr32 C:\WINDOWS\system32\msxml3.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.
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:\WINDOWS\system32\msxml.dll
regsvr32 C:\WINDOWS\system32\msxml3.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.
