Feb 18, 2010

Solution: SQL 2000 to SQL 2005 upgrade error -1

I was trying to perform an upgrade at a Microsoft site from SQL 2000 to SQL 2005. I had a pop up window during the upgrade analysis process of SQL 2005 that was blank.
The message I was getting in the WI install log located at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup000#_computername_WI.log was Error Code: 0x80077370 (29552)

The Problem is in Upgrade advisor. In my case it was failing because .Net 3.5 SP1 was installed.
The following workaround amazed me and worked perfectly:

"Once SQL installation starts create a subdirectory BPAClientunder C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA directory. And copy BPAClient.dll (from the sibling bin directory) into this directory."
(http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.setup/2008-10/msg00265.html)
The BPAClient.dll file can be found at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin.