A customer just emailed me about an issue with SQL Server Express failing. The error he saw in the logs are:
SQL Server Setup failed to execute a command for
server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot alter the login ‘sa’, because it does not exist or you do not have permission.. Refer to the server error logs and Setup logs for detailed error information.
I’ve been talking to the SQL team about this and they know about the issue and are working on a fix. For now, the workaround is to verify your permissions and make sure you’re an administrator. If you’re a power user and an administrator, you must make sure the administrator group is listed first. It seems the SQL Setup lmight be looking at the first group and not all the groups. Also, make sure the account you’re using is also in the User’s group.