I went to upgrade my old MSDE database to SQL 2005 Express on our McAfee EPO server and I was receiving a ‘-1’ error during the upgrade process with the detail of:
You selected Mixed Mode authentication, but did not provide a strong password. To continue you must provide a strong sa password.
I went through a bunch of different items, but this link detailed that the error is in fact caused by a bum installer of Microsoft’s design:
Copy C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin\BPAClient.dll to C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA
This was one of those ‘no way’ errors that aggravated me to no end. Why didn’t they fix this?