My initial joy of having a brand new service pack for SQL Express is now turned to frustration. For some stupid reason, I can't install the service pack on my test server. I'm currently running a Community Server Test site, and don't feel like uninstalling the whole SQL Server Express to upgrade it to SP1.
Error says:
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
For help, click:
http://go.microsoft.com/fwlink?LinkID=20476
------------------------------
BUTTONS:
&Retry
Cancel
------------------------------
I really can't figure this one out, and there's very little information online yet. I've seen others struggle with the same problem, but none of them seem to have manage to figure it out either. My biggest question is "Why does it want to use the SA account?"? I'm not even using SQL Authentication, only Windows Authentication. No wonder it can't log in with the SA account, it's not allowed!!! And this also messes up the installation of Reporting Services. Not happy right now.
Update: The SQL Server Express team has picked up on the frustration, and written some docs on how to install the Advanced Services properly. Yey! Read instructions at
How to upgrade from SQL Express to SQL Express Advanced
and
"Login failed for user ‘sa’" error when upgrading to SQL Server 2005 Express Edition with Advanced Services
Will have to test those as soon as possible.