SQL Server 2005 Express: upgrading to SP3 in mixed-mode installations

Posted by Jeroen Pluimers on Server Fault See other posts from Server Fault or by Jeroen Pluimers
Published on 2010-06-17T20:27:34Z Indexed on 2010/06/17 20:33 UTC
Read the original article Hit count: 570

Filed under:

sql-server-2005

|

password

|

upgrade

|

mixed-mode

I'm having trouble upgrading SQL Server 2005 Express SP1 to SP3.

The SP1 install uses mixed mode authentication (so there is an sa password).

This is the message I get:

TITLE: Microsoft SQL Server Setup
------------------------------
None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install. To exit SQL Server Setup, click Cancel.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28108
------------------------------
BUTTONS: OK
------------------------------

The link then tells me To continue you must provide a strong sa password.

I tried some searching, and found something about BPAClient.dll, but this batch-file does not fix it:

mkdir "%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\BPA\BPAClient"
copy "%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin\BPAClient.dll" "%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\BPA\BPAClient\"

So I think the clue is the strong in the link above.
Am I on the right track?
Where do I find more information on the strongness of an sa password?

--jeroen (who will adjust the question when he has dug further)

Developer IT