I have found the issue. Problem is Upgrade advisor is failing if the
system has .Net 3.5 SP1 is installed. I found the following workaround
with which upgrade advisor is working fine.

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.

Can any one suggest how i can proceed on this?

I have found the issue. Problem is Upgrade advisor is failing if the
system has .Net 3.5 SP1 is installed. I found the following workaround
with which upgrade advisor is working fine.

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.

Can any one suggest how i can proceed on this?

I have found the issue. Problem is Upgrade advisor is failing if the
system has .Net 3.5 SP1 is installed. I found the following workaround
with which upgrade advisor is working fine.

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.

Can any one suggest how i can proceed on this?

Can any one suggest how i can proceed on this?

I just did what the issue says and it works.

Wkr.



chaitu wrote:

I have found the issue.
01-Nov-08

I have found the issue. Problem is Upgrade advisor is failing if the
system has .Net 3.5 SP1 is installed. I found the following workaround
with which upgrade advisor is working fine.

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.

Can any one suggest how i can proceed on this?

Previous Posts In This Thread:

On Saturday, November 01, 2008 2:38 AM
chaitu wrote:

Failed to upgrade from SQL Server 2000 to SQL Server 2005
Hi,

We have release 1 which has SQL Server 2000. Now we are coming up
with release 2 which will have SQL Server 2005. When we are upgrading
from release 1 to release 2, we are also upgrading SQL Server 2000 to
SQL Server 2005. When we are upgrading to SQL Server 2005, we are
getting following -
UpgradeAdvisor: returned -1.
Error message:

Nothing is displaying in error message. Its blank.

In release 2, we have .Net 3.5 SP1 installation also. Previously when
release 2 doesnt have .Net 3.5 SP1 installation, we were able to
upgrade to SQL Server 2005 successfully. Once we have included .Net
3.5 SP1 installation before we acutally upgrade to SQL Server 2005, we
are getting this error.

Is there any thing to do with .Net 3.5 SP1 installation.
Also, in the log files, it is talking about virtualization. But we
are doing installation on actual machine and not on any virtual
machine.

Here is the error message snapshot from the SQL Server log files -

MSI (s) (BC:74) [14:29:02:765]: Doing action:
ValidateUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882 C2
Action ended 14:29:02:
DetectInstallPaths.D20239D7_E87C_40C9_9837_E70B8D4 882C2. Return value
1.
MSI (s) (BC:A8) [14:29:02:765]: Invoking remote custom action. DLL: C:
\WINDOWS\Installer\MSI245.tmp, Entrypoint: ValidateUpgrade
Action start 14:29:02:
ValidateUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882 C2.
<Func Name='LaunchFunction'>
Function=ValidateUpgrade
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: ValidateUpgrade
PerfTime Start: ValidateUpgrade : Wed Oct 22 14:29:02 2008
<Func Name='ValidateUpgrade'>
Added FTE to SqlUpgrade property
Added REPL to SqlUpgrade property
<Func Name='updateFeatureSellection'>
Running:
CollectInstallCases
at:
Info 2008.2008
/
9
/
22

14
29
2


Complete:
CollectInstallCases
at:
Info 2008.2008
/
9
/
22

14
29
2
, returned
true


Running:
DefineFeatureActionRules
at:
Info 2008.2008
/
9
/
22

14
29
2


Complete:
DefineFeatureActionRules
at:
Info 2008.2008
/
9
/
22

14
29
2
, returned
true


Running:
DefineInstallActionRules
at:
Info 2008.2008
/
9
/
22

14
29
2


Complete:
DefineInstallActionRules
at:
Info 2008.2008
/
9
/
22

14
29
3
, returned
true


Running:
AddInstallCaseActions
at:
Info 2008.2008
/
9
/
22

14
29
3


Complete:
AddInstallCaseActions
at:
Info 2008.2008
/
9
/
22

14
29
3
, returned
true


Loaded DLL:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlboot.dll
Version:
2005.90.1399.0


Action "
languageUpgrade_MSSQLSERVER SQL 8.0 SQL Server Standalone Product
MSSQLSERVER
" will be skipped due to the
following restrictions:


Condition "differentLanguage_with_1033_MSSQLSERVER SQL 8.0 SQL Server
Standalone Product MSSQLSERVER" returned false.

Loaded DLL:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlboot.dll
Version:
2005.90.1399.0


Action "
maintenance_MSSQLSERVER SQL 8.0 SQL Server Standalone Product
MSSQLSERVER
" will be skipped due to the
following restrictions:


Condition "sameVersion_as_9.0.139906_MSSQLSERVER SQL 8.0 SQL Server
Standalone Product MSSQLSERVER" returned false.

Loaded DLL:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlboot.dll
Version:
2005.90.1399.0


Action "
skuUpgrade_MSSQLSERVER SQL 8.0 SQL Server Standalone Product
MSSQLSERVER
" will be skipped due to the
following restrictions:


Condition "NOT_sameSKU_MSSQLSERVER SQL 8.0 SQL Server Standalone
Product MSSQLSERVER" returned false.

Loaded DLL:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlboot.dll
Version:
2005.90.1399.0


Action "
virtualization_MSSQLSERVER SQL 8.0 SQL Server Standalone Product
MSSQLSERVER
" will be skipped due to the
following restrictions:


Condition "virtualization_NotSupported_MSSQLSERVER SQL 8.0 SQL Server
Standalone Product MSSQLSERVER" returned false.

Action "
warningPatchLevel_MSSQLSERVER SQL 8.0 SQL Server Standalone Product
MSSQLSERVER
" will be skipped due to the
following restrictions:


Condition "diffInstancePatchLevel_MSSQLSERVER SQL 8.0 SQL Server
Standalone Product MSSQLSERVER" returned false.

Action "
warningSPLevel_MSSQLSERVER SQL 8.0 SQL Server Standalone Product
MSSQLSERVER
" will be skipped due to the
following restrictions:


Condition "diffInstanceSPLevel_MSSQLSERVER SQL 8.0 SQL Server
Standalone Product MSSQLSERVER" returned false.

Action "
warningUpgrade_MSSQLSERVER SQL 8.0 SQL Server Standalone Product
MSSQLSERVER
" will be skipped due to the
following restrictions:


Condition "warningUpgrade_MSSQLSERVER SQL 8.0 SQL Server Standalone
Product MSSQLSERVER" returned false.

Running:
versionUpgrade_MSSQLSERVER SQL 8.0 SQL Server Standalone Product
MSSQLSERVER
at:
Info 2008.2008
/
9
/
22

14
29
3


Complete:
versionUpgrade_MSSQLSERVER SQL 8.0 SQL Server Standalone Product
MSSQLSERVER
at:
Info 2008.2008
/
9
/
22

14
29
3
, returned
true


Running:
AddFeatureCase_versionUpgrade_MSSQLSERVER SQL 8.0 SQL Server
Standalone Product MSSQLSERVER
at:
Info 2008.2008
/
9
/
22

14
29
3


Complete:
AddFeatureCase_versionUpgrade_MSSQLSERVER SQL 8.0 SQL Server
Standalone Product MSSQLSERVER
at:
Info 2008.2008
/
9
/
22

14
29
3
, returned
true


Running:
FeaturePhaseAction
at:
Info 2008.2008
/
9
/
22

14
29
3


Complete:
FeaturePhaseAction
at:
Info 2008.2008
/
9
/
22

14
29
3
, returned
true


Action "
add_MSSQLSERVER SQL 8.0 SQL Server Standalone Product
MSSQLSERVER_SQL_Engine
" will be skipped due to the
following restrictions:


Condition "noFeatureConflict_MSSQLSERVER SQL 8.0 SQL Server Standalone
Product MSSQLSERVER_SQL_Engine" returned false.
Condition "NOT_featureInstalled_MSSQLSERVER SQL 8.0 SQL Server
Standalone Product MSSQLSERVER_SQL_Engine" returned false.
Condition "installActionAvailable_maintenance_MSSQLSERVE R SQL 8.0 SQL
Server Standalone Product MSSQLSERVER_SQL_Engine" returned false.

Action "
remove_MSSQLSERVER SQL 8.0 SQL Server Standalone Product
MSSQLSERVER_SQL_Engine
" will be skipped due to the
following restrictions:


MSI (s) (BC!5C) [14:29:03:421]: PROPERTY CHANGE: Deleting AGTACCOUNT
property. Its current value is 'OPMSERVERB\mngr'.
MSI (s) (BC!5C) [14:29:03:421]: PROPERTY CHANGE: Deleting AGTPASSWORD
property. Its current value is '**********'.
Condition "installActionAvailable_maintenance_MSSQLSERVE R SQL 8.0 SQL
Server Standalone Product MSSQLSERVER_SQL_Engine" returned false.

Attempt to start service when it is already running
SQL service MSSQLSERVER started successfully waiting for SQL service
to accept client connections
Loaded DLL:
C:\WINDOWS\system32\Odbc32.dll
Version:
3.526.3959.0


SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect
sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft]
[SQL Native Client][SQL Server]Changed database context to 'master'.
sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft]
[SQL Native Client][SQL Server]Changed language setting to us_english.

Executing External Command
Message type: Progress
10
Message type: Component
Database Engine
Message type: Status
Checking for SQL Connectivity...
Message type: Status
Starting analysis...
Message type: Status
Creating report
Message type: Status
Creating report
Message type: Progress
Info 100.100
UpgradeAdvisor.returned 4294967295
Error Code: 0x80077370 (29552)
Windows Error Text: Source File Name: sqlca\sqlguica.cpp
Compiler Timestamp: Mon Aug 29 01:18:41 2005
Function Name: IsUpgradeBlocked
Source Line Number: 4441



---- Context -----------------------------------------------


Setting status of unmanaged components and removing unmanaged
resources



Error Code: 29552
MSI (s) (BC!5C) [14:32:28:828]: Product: Microsoft SQL Server 2005 --
Error 29552. UpgradeAdvisor returned -1 .
Error message:

Error 29552. UpgradeAdvisor returned -1 .
Error message:
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: ValidateUpgrade
PerfTime Start: ValidateUpgrade : Wed Oct 22 14:32:28 2008
<Func Name='ValidateUpgrade'>
Added FTE to SqlUpgrade property
Added REPL to SqlUpgrade property
<Func Name='updateFeatureSellection'>
Attempt to start service when it is already running
SQL service MSSQLSERVER started successfully waiting for SQL service
to accept client connections
Loaded DLL:
C:\WINDOWS\system32\Odbc32.dll
Version:
3.526.3959.0


SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect
sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft]
[SQL Native Client][SQL Server]Changed database context to 'master'.
sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft]
[SQL Native Client][SQL Server]Changed language setting to us_english.

Executing External Command
Message type: Progress
10
Message type: Component
Database Engine
Message type: Status
Checking for SQL Connectivity...
Message type: Status
Starting analysis...
Message type: Status
Creating report
Message type: Status
Creating report
Message type: Progress
Info 100.100
UpgradeAdvisor.returned 4294967295
Error Code: 0x80077370 (29552)
Windows Error Text: Source File Name: sqlca\sqlguica.cpp
Compiler Timestamp: Mon Aug 29 01:18:41 2005
Function Name: IsUpgradeBlocked
Source Line Number: 4441

On Saturday, November 01, 2008 2:38 AM
chaitu wrote:

I have found the issue.
I have found the issue. Problem is Upgrade advisor is failing if the
system has .Net 3.5 SP1 is installed. I found the following workaround
with which upgrade advisor is working fine.

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.

Can any one suggest how i can proceed on this?

On Thursday, February 19, 2009 1:46 PM
Upgrade error wrote:

Error with SQL Express Service Pack 3
I just wanted to post here that your solution was perfect. I couldn't install SQL Express Service Pack 3. It would error out with that -1 error which lead to: http://www.microsoft.com/products/ee... EvtType=28112

To continue you must provide a strong sa password.

You selected Mixed Mode authentication, but did not provide a strong password.

That meant nothing to me. And then I stumbled across your post and I created a BPAClient folder and copied the BPAClient.dll into it and no more error. The service pack installed successfully.

Thanks.


Submitted via EggHeadCafe - Software Developer Portal of Choice
File-Based Cache for Web and non-Web Apps plus Extend ASP.NET 4.0 OutputCacheProvider
http://www.eggheadcafe.com/tutorials...e-for-web.aspx

It worked like a charm, thanks!