Second Stanza

October 23, 2008

SQL Server 2005 Installation Problem

Filed under: SQL Server — Tags: — dfbaskin @ 11:36 am

For some reason, when running the SQL Server 2005 Upgrade Advisor (either the stand-alone version or the version that runs within the installation), I was getting the following error:

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

The problem, it turns out, is that BPACMD.EXE was not able to load BPAClient.dll for some reason. The work around was to copy the BPAClient.dll to a location that allowed BPACMD.EXE to load it. The file resides in a “bin” directory below a “BPA” directory. I simply created a “BPA\BPAClient” directory and copied BPAClient.dll into this directory. (The reason this works is that the .NET runtime will search this directory when trying to load BPAClient.dll.)

Note that you must copy this file after the SQL Server support files have been installed (usually to the Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA directory).

A forum discussion of this topic is here.

I am not sure the reason this intervention is required, but I suspect it has something to do with the installation of the .NET 3.5 SP1 runtime.


  1. Thank you ! This advice helps me so much :-)

    Comment by Steve Branney — August 8, 2010 @ 8:23 am

  2. Thanks! You’re a lifesaver!

    Comment by Ryan — January 14, 2011 @ 3:54 pm

  3. Thank you very much. This saved me hours of wasted time.

    Comment by Wes — April 1, 2011 @ 11:14 pm

  4. SUPER DAAAANNNKKE, auf so etwas kann man doch nicht kommen.
    Habe mich dann auch durch die logs gehangelt und dann noch diesen Beitrag gefunden.
    Danke schön. So einfach und schnell kann es gehen.

    Comment by Hubert — April 30, 2011 @ 6:23 pm

  5. Thank you! you saved us a lot of time!

    Comment by Ram — June 3, 2011 @ 12:24 am

  6. You are THE MAN!!!!!
    SP4 for SQL2005 was failing, it drove me nuts.
    I tried a ton of solutions – until yours solved it.

    Comment by Non Anon — June 20, 2011 @ 8:02 pm

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: