Upgrading an MSDE instance to SQL Server 2005 when .NET 3.5 SP1 is installed may fail on SQL BPA command line [Q12575]

	Browse		Search		Login

Home : Upgrading an MSDE instance to SQL Server 2005 when .NET 3.5 SP1 is installed may fail on SQL BPA command line

Q12575 - KNOWNISSUE: Upgrading an MSDE instance to SQL Server 2005 when .NET 3.5 SP1 is installed may fail on SQL BPA command line

Upgrading an MSDE instance to SQL Server 2005 when .NET 3.5 SP1 is installed may fail

Issue

Consider the following scenario:

You are running an OPS SQL edition that installs its own MSDE (SQL Server 2000) database
You are upgrading to Hach WIMS
You have version 3.5 SP1 of the .NET framework installed

The Hach WIMS Platform Bootstrapper will attempt to upgrade MSDE to SQL Server 2005 by launching the SQL Server 2005 setup program with instructions to upgrade MSDE. The setup program may then crash with the following error:

OR, you may get a message saying that the MS SQL Ugrade advisor failed with error -1 and a blank error message.

The Bootstrapper will then report the following error:

This is a known problem with the SQL Server 2005 setup program.

Work-around

Once SQL installation starts, create a subdirectory BPAClient under C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA directory.and copy BPAClient.dll (from the sibling bin directory) into
this directory: