Problems with SQL 2005 Upgrade Advisor

For those of us that are still in situations where we deal primarily with SQL Server 2000, there should come a time when we have to run the Microsoft SQL Server 2005 Upgrade Advisor. Some of you may be going straight to SQL Server 2008 and this issue may be resolved in the SQL Server 2008 Upgrade Advisor.

During the initial run of the wizard, an error will pop up without giving you many details. In my case, I look at the event viewer and see the following:

.Net 2 Runtime Error

.Net 2 Runtime Error

If you browse the internet you’ll find various ideas to fix it. Some suggest removing all .Net versions and reinstalling them. Some suggest not putting on .Net 2 SP1 until you run it. Another suggestion is to change the Aspnet.config file to read <legacyUnhandledExceptionPolicy enabled=”true” />. None of these suggestions worked for me.

The fix that got me working was to copy all of the files from within the \BPA\Bin folder and paste them into \BPA\.

I think I would try this first before going through all that other trouble. If this doesn’t work you can always explore the other options.

Resources:
http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/2a5f460b-8684-4510-8fcb-1e9d9786baff/
http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/390e8a17-bd66-4426-b24c-d0a5cc009053
http://www.sqlservercentral.com/Forums/Topic561810-5-1.aspx
http://support.microsoft.com/kb/911816
http://sqllearnings.blogspot.com/2009/04/microsoft-sql-server-2005-upgrade.html
http://devel.virtage.com/2009/01/en-crashing-sql-server-2005-upgrade-advisor-error/

,