SQL BPA Command line has encountered a problem and needs to close...

Expand / Collapse
 

SQL BPA Command line has encountered a problem and needs to close...


Symptom

The following error occurs when installing 'Microsoft SQL Server 2005 Express Edition Service Pack 3':

SQL BPA Command line has encountered a problem and needs to close.

Cause

This issue seems to happen if .Net Framework 3.5 SP1 is already installed on the server before executing the 'Microsoft SQL Server 2005 Express Edition Service Pack 3' setup.

If you view the 'Application Event Log' after the failure occurs, you can see more information about the error.  

The error 29552 shown in the MsiInstaller error means that the Upgrade Advisor (SQL tool used during setup) encountered a problem when dealing with Reporting Services.

If you open the RS.log log file located under C:\Documents and Settings\Administrator\Application Data\Microsoft\SQL Server 2005 Upgrade Advisor\log, you can get more information about what leads the Upgrade Advisor to fail.  The information in the log file indicates that the BpaCmd.exe command line (called by the Upgrade advisor) failed because it couldn’t locate the file BPAClient.dll (causing the FileNotFoundException exception).

Fix

1. Copy the BPAClient.dll file located under C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin to C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\BPA

2. Run the SQL 2005 SP3 setup again



Rate this Article:
     

Add Your Comments


Name: *
Email Address:
Web Address:
 

Details
Last Modified:Tuesday, May 12, 2009
Last Modified By: Craig Goulding
Type: ERRDOC
Level: Intermediate
Article not rated yet.
Article has been viewed 10,167 times.
Options