October 27, 2008 at 1:11 pm
Hi folks 🙂
I have a 64-bit vista ultimate PC with all SP's applied.
I have been attemting to upgrade the existing instance of SQL Server Expr to SP2, but it stops installing with an error dialog box saying:
[highlight=#ffff11]SQL BPA command line has stopped working[/highlight]
Eventually I end up on a web page containing the following info:
[highlight=#ffff11]Details
Product:SQL Server
ID:SQLSetup90
Source:setup.rll
Version:9.00.1291.00
Component:SQL Server Setup
Message:To continue you must provide a strong sa password.
Explanation
You selected Mixed Mode authentication, but did not provide a strong password.[/highlight]
When I open up Management Studio Expr and examine Server Properties for the existing instance, it shows "Windows Authentication". Within the installation wizard I definitely have chosen "Windows Authentication".
So, currently I am somewhat mystified.
If somebody could give me a hand with this it would be wonderful.
Kind regards
Ross 🙂
October 31, 2008 at 6:40 am
Microsoft says their independent SP2 upgrade is good for all SQL 2005 except Express (http://www.microsoft.com/downloads/details.aspx?FamilyID=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en). There it reads,
Note: To upgrade SQL Server 2005 Express Edition, obtain the SP2 version of Express Edition or Express Edition with Advanced Services.
November 5, 2008 at 7:31 pm
Hi dcorbitt 🙂
Thanks for your help - have been very busy with an extension on our home, so have been unable to reply till now.
I had a look at the link you put into the last message and of course you are right. I clicked on the link on the MS page which took me to .
On that page, in the RH column there is a download for SQL Server 2005 Express Edition with Advanced Services SP2, so I downloaded it and then ran the file after the download had completed.
Unfortunately the exact same problem happened again, so I am still mystified.
What do you think?
Kind regards
Ross
November 6, 2008 at 7:24 am
BPA appears to stand for SQL "Best Practices Analyzer." I'm not sure why it's giving you grief, but here are some thoughts.
1. Logs
1a. Is there a "summary.txt" file at "Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG"? If so, does it offer any clues on the failure?
1b. Are there any current log files in "Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files"? Any clues there?
1c. Are there errors logged in the Event Viewer?
2. Vista.
2a. Are you logged in as an admin AND are you right-clicking the install and choosing "Run as Administrator"? (Granted, I have minimal experience with Vista.)
2b. Are you able to install on another Vista machine?
3. Prereqs. Does your machine have all of the necessary prerequisites for Express? http://msdn.microsoft.com/en-us/library/ms143680(SQL.90).aspx
4. Pwd. You might give in and go mixed mode for the install with a strong SA pwd http://www.microsoft.com/protect/yourself/password/checker.mspx, and then switch to Windows only.
I guess you've already un-installed the original instance, or are you installing a separate instance?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply