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

Article translations Article translations
Article ID: 917827 - View products that this article applies to.
Expand all | Collapse all

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: June 11, 2007 - Revision: 1.2
APPLIES TO
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Express Edition with Advanced Services
  • Microsoft SQL Server 2005 Workgroup Edition
Keywords: 
kbprb kbtshoot kbsql2005setup kbexpertiseadvanced KB917827

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com