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:
SQL BPA command line has stopped working
Eventually I end up on a web page containing the following info:
Product: SQL Server
Component: SQL Server Setup
Message: To continue you must provide a strong sa password.
You selected Mixed Mode authentication, but did not provide a strong password.
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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!