Upgrade SQL 2000 to 2005 Error –1 “Password Strength”

By | March 10, 2010

I know this might be kind of late for some of you but I just had to perform an upgrade to our SQL server as our last vendor now supports SQL 2005.

But I ended up with a problem. When upgrading I got an error (-1). What the hell it that? It was totally non-descript. When clicking on help it stated that I was not using a strong password!?! I was using Windows authentication so i decided to use the “sa” login and got the same error. Then proceeded to look for the fix.

I found it on eggheadcafe.com

Go to c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin

Copy BPAClient.dll

Go up one level to c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA

Paste BPAClient.dll there and then try the install!

Then it works.

Thanks to chaitu for this fix.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.