Bosch Building Technologies

    cancel
    Showing results for 
    Search instead for 
    Did you mean: 

    How to: Error Installing SQL Server 2005 Express SP3

     

    Related Products

    RPS 5.12

    Overview

    Helps when encountering error 'SQL BPA Command line has encountered a problem and needs to close' when running the Windows Installshield Wizard for Microsoft SQL Server 2005 Express Edition Server Pack 3 (SP3).

    Issue

    If you open the Application Event Log in the event viewer after the failure, you can notice the error below:

     

    The error 29552 indicated 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.

     

    This indicated 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).

    Solution

    There is a simple workaround that you can use in order to achieve the setup of SQL Server 2005 Express Edition Service Pack 3 with success.

     

    Here are the steps of the workaround:

     

    • 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'.
    • Run the SQL 2005 SP3 setup again.
    Notes
    Version history
    Last update:
    ‎05-22-2018 12:45 PM
    Updated by:
    Labels (2)
    Contributors
    Icon--AD-black-48x48Icon--address-consumer-data-black-48x48Icon--appointment-black-48x48Icon--back-left-black-48x48Icon--calendar-black-48x48Icon--center-alignedIcon--Checkbox-checkIcon--clock-black-48x48Icon--close-black-48x48Icon--compare-black-48x48Icon--confirmation-black-48x48Icon--dealer-details-black-48x48Icon--delete-black-48x48Icon--delivery-black-48x48Icon--down-black-48x48Icon--download-black-48x48Ic-OverlayAlertIcon--externallink-black-48x48Icon-Filledforward-right_adjustedIcon--grid-view-black-48x48IC_gd_Check-Circle170821_Icons_Community170823_Bosch_Icons170823_Bosch_Icons170821_Icons_CommunityIC-logout170821_Icons_Community170825_Bosch_Icons170821_Icons_CommunityIC-shopping-cart2170821_Icons_CommunityIC-upIC_UserIcon--imageIcon--info-i-black-48x48Icon--left-alignedIcon--Less-minimize-black-48x48Icon-FilledIcon--List-Check-grennIcon--List-Check-blackIcon--List-Cross-blackIcon--list-view-mobile-black-48x48Icon--list-view-black-48x48Icon--More-Maximize-black-48x48Icon--my-product-black-48x48Icon--newsletter-black-48x48Icon--payment-black-48x48Icon--print-black-48x48Icon--promotion-black-48x48Icon--registration-black-48x48Icon--Reset-black-48x48Icon--right-alignedshare-circle1Icon--share-black-48x48Icon--shopping-bag-black-48x48Icon-shopping-cartIcon--start-play-black-48x48Icon--store-locator-black-48x48Ic-OverlayAlertIcon--summary-black-48x48tumblrIcon-FilledvineIc-OverlayAlertwhishlist