There should exist on the server a directory named, C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\.
Create a new directory in this location named BPAClient. You will end up with C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\BPA\BPAClient.
Copy the BPAClient.dll from the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\Bin directory into this newly created
BPAClient directory and try the installation again.
Note: This is directly from an email I sent to support someone who was having this issue on their server and it worked for them. They were running Windows XP.
Anonymous Internet User
March 4, 2009 at 3:13 pm
This solved our problems with upgrading perfectly. Thank you for posting this succint solution!
Jill
March 9, 2010 at 3:35 pm
Life saver, thanks
Jerry
March 13, 2009 at 7:24 pm
Fantastic…..Worked for my upgrade from SQL Server 200 + 2005
Dave Stuart
April 7, 2009 at 11:24 pm
Brilliant! Thanks for this solution. It’s been on my to do list for a few weeks.
x3haloed
April 21, 2009 at 11:38 am
Worked great. Thanks!
rgoliam
May 4, 2009 at 10:21 am
extra !!! thx
Josh
May 12, 2009 at 6:42 pm
Thanks! Worked great but it would be nice if Microsoft would fix this. You blogged about this in January 2009 and I’m just installing SP3 update today in May and I still get the same error.
Dan
April 12, 2012 at 9:22 am
Even worse I’m installing this in 2012 and Microsoft still has not fixed it and by now I think they never will.
Chromos
June 3, 2009 at 4:07 am
Worked for me too! Huge thanks!
Daniel
July 30, 2009 at 12:07 am
Thank you so MUCH!!!
Jon
August 2, 2009 at 2:12 am
GREAT!! I have been struggling with this issue on XP for a long time now, and this solved it. Thanks!
Chuck
August 6, 2009 at 4:15 pm
Wow this worked great!!
Rolo
August 20, 2009 at 3:12 pm
Very much thanks,
))
this was the resolution for my Problem!
WSokx
September 8, 2009 at 10:26 am
bravo, briliant solution, worked for me
PatriotsRock
September 10, 2009 at 12:14 pm
This worked great thanks for Posting
CyberDaeng
October 6, 2009 at 2:47 am
Excellent post. Help me a lot…
Tony
October 6, 2009 at 11:24 am
Tried this on a Vista Machine and it worked like a charm
Daniel
October 8, 2009 at 11:31 am
Many thanks; worked for me on a W2003SP2 box.
Mike
October 19, 2009 at 8:39 am
It works with the advisor too but it´s an other path.
C:\Program Files\Microsoft SQL Server 2005 Upgrade Advisor\BPA\
Then same steps as described
mdoyle
November 17, 2009 at 10:06 pm
God bless you, Villagecoder.
Anonymous
November 18, 2009 at 2:42 am
Yes, this works. Thanks alot!
Marco
November 19, 2009 at 6:32 am
Thanks alot …. Works perfect!
Raster
November 26, 2009 at 11:07 am
Thank you . It’s works perfektly on Windows XP.
MF
December 2, 2009 at 12:47 pm
Perfect!!!
Seantron
December 2, 2009 at 4:10 pm
Worked great for XP! Thanks!
KGA
January 16, 2010 at 1:54 pm
Thanks for posting. Saved a whole weekend.
Pascal
January 18, 2010 at 10:44 am
Solved my problem too.. thank you very much!
Miriam
February 5, 2010 at 11:46 am
Thank you so much! This solved my problem
Travis
February 17, 2010 at 9:36 pm
This was perfect, solved the problem right away. THANKS a TON!!!!!
sqlsamson
February 18, 2010 at 10:10 pm
Spot on man! Believe it or not this is the first time I have had to upgrade SQL Server 2000 to 2005. Typically I have had the pleasure of always deploying new except for today. Thanks for the info!
dotnetolympians
March 2, 2010 at 4:44 am
saved me a lot of time thanks and mike is right about the location its not always in the program files
dkhilo
March 24, 2010 at 1:19 am
Thank you so very much, this error kept coming up when upgrading from MSDE.
Ted
March 31, 2010 at 5:51 pm
Fantastic thanks so much it work well ..
Jonas
April 6, 2010 at 6:51 am
worked great! Thanks…
Braun
April 9, 2010 at 3:47 pm
Brilliant. I can leave office, because my work is done! Thank you very much!
AG computers
April 14, 2010 at 3:56 pm
You rock! Thanks
FireWire33Red
April 23, 2010 at 6:13 am
Thanks worked like a charm…..
Bapaiah
April 27, 2010 at 3:22 pm
Thanks worked for me
Eken
May 18, 2010 at 7:54 am
Thanks!!! Worked for us too!
Dhruva
May 21, 2010 at 4:16 pm
Thanks a millions……..
Luca
June 15, 2010 at 9:28 am
Thank you man!!!
Sriharish
July 13, 2010 at 5:39 am
Great ………………………….It works Thank you very much…………
mar
July 24, 2010 at 7:39 pm
rock on dude!
prmartins
September 9, 2010 at 7:15 am
Genius…
Anonymous
September 14, 2010 at 8:05 am
thank you and google
Danijel siemens hater
November 14, 2010 at 9:39 pm
Tnx a lot!!!!!!!!!!!
Anonymous
November 29, 2010 at 1:04 pm
Awesome! Perfect! THANK YOU!
Anonymous
March 4, 2011 at 3:32 am
Nice fix. Thanks.
Robert Baker
March 16, 2011 at 5:42 am
Well played sir. I’ve got SQL 2005 Express With Advanced Services on Server 2003 that’s been quietly failing to apply SP 4 for months. This did the trick.
Tony Källebring
March 25, 2011 at 6:11 am
Thank you very much!
Riccardo Facchini
April 13, 2011 at 9:43 am
Thanks! great help
Jay Nicol
May 29, 2011 at 1:25 pm
It’s amazing that such a critical process can be subject to the same old flaws from Microsoft.
Thank you for providing a simple solution that was easy to find. Kind of made my day!
Jay
James Payne
June 21, 2011 at 8:58 am
Saved me a call to Micro$oft, thanks!
Matthias Elflein
July 21, 2011 at 9:38 am
Simple sulotion for a big problem. Thanx!
nik
August 16, 2011 at 9:16 am
Great solution! Worked pefectly.
Spark
August 17, 2011 at 5:44 pm
THANK YOU for posting this. I finally got a successful install!
s
September 19, 2011 at 6:37 pm
awesome!
Darren
October 5, 2011 at 8:13 pm
Finally a solution. Thanks it worked as well on Server 2008!
Anonymous
November 22, 2011 at 8:37 pm
THANK YOU!!!!!!!!!!!! IT WORKED GREAT!!!!!!!!!!!!!!
scottydel
November 28, 2011 at 5:19 pm
Villagecoder you are a shogun warrior ninja. Worked for me on XP running SQL Server 2005 Express trying to install Service Pack 4. Amazing MS hasn’t updated this yet, they should cut you a check.
villagecoder
March 9, 2012 at 5:05 pm
Probably my favorite comment ever!!
TJ
January 26, 2012 at 3:47 am
This problem has plagued me for a couple of years now ~ great to see a fix! So glad you posted this. Thank you.
Anonymous
February 23, 2012 at 4:48 am
Thanks for this …it is of great help…
Anonymous
April 18, 2012 at 5:44 pm
Thanks for sharing the solution.