Error message when you install SQL Server 2005: "Cannot alter the login 'sa', because it does not exist or you do not have permission"

Symptoms

When you install Microsoft SQL Server 2005, you may receive the following error message:
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.

Cause

This problem occurs because you tried to install SQL Server 2005 on a domain computer that has a Windows group or a user who has one of the following names:
  • sa
  • Sa
  • sA
  • SA
The Setup program cannot call the
sp_SetAutoSAPasswordAndDisable stored procedure to disable the sa login when Windows Authentication mode is selected.

Workaround

To work around this problem, select the Mixed Mode (Windows Authentication and SQL Server Authentication) option when you install SQL Server 2005.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Properties

Article ID: 917827 - Last Review: Jun 16, 2008 - Revision: 1

Feedback