Error message when you install SQL Server 2005 Express Edition Service Pack 1 in Windows Vista: "Windows NT user or group '<COMPUTERNAME>\SQLServer2005MSSQLUser$<COMPUTERNAME>$MSSQLSERVER' not found"
This article has been archived. It is offered "as is" and will no longer be updated.
When you try to install Microsoft SQL Server 2005 Express Edition Service Pack 1 (SP1) on a computer that is running Windows Vista, you 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]Windows NT user or group 'COMPUTERNAME\SQLServer2005MSSQLUser$COMPUTERNAME$MSSQLSERVER' not found. Check the name again.. Refer to the server error logs for detailed error information.
This problem occurs if the following conditions are true:
- The Windows Vista-based computer has a name that consists of lowercase characters or that consists of a mixture of lowercase characters and uppercase characters. For example, the computer name resembles Workstation-1.
- You specify a case-sensitive collation setting for the SQL Server service when you install SQL Server 2005 Express Edition SP1.
- Windows Vista can return the computer name in uppercase characters.
- Windows Vista can return the computer name in the actual mixed case characters that appear in the System Properties dialog box.
The SQL Server 2005 Express Edition Setup program compares the received computer names. Generally, this does not cause a problem because computer names are not case sensitive in Windows Vista. However, if a case-sensitive collating sequence is specified when you install SQL Server 2005 Express Edition, the result of the name comparison between the computer name in uppercase characters and the computer name in mixed case characters fails. Therefore, the installation of SQL Server 2005 Express Edition SP1 is unsuccessful.
To work around this problem, use one of the following methods.
Method 1: Change the computer name to use only uppercase charactersA computer name is not case sensitive in Windows. For example, Windows recognizes "Workstation-1" and "WORKSTATION-1" as the same computer name. To change the computer name, follow these steps:
- Click Start, right-click Computer, and then click Properties.
- Under Computer name, domain, and workgroup settings, click Change settings.
If you are prompted for an administrator password or for a confirmation, type your password, or click Continue.
- In the System Properties dialog box, click Change.
- In the Computer name box, note the original computer name, and then type a temporary computer name in uppercase characters. For example, type WORK-TMP.
- Click OK.
Note If you are prompted to enter the name and password of a domain account that has permission to rename the computer, type your credentials, and then click OK.
- When you are prompted to restart the computer to apply the changes, click OK, click Close, and then click Restart Now.
- Follow steps 1 through 6 to change the computer name to the original computer name. When you specify the original computer name, type the name in uppercase characters. For example, type WORKSTATION-1 instead of Workstation-1.
- Install SQL Server 2005 Express Edition SP1.
Method 2: Use a case-insensitive collation setting for the SQL Server serviceWhen you install SQL Server 2005 Express Edition SP1, do not select a case-sensitive collation setting. For more information about how to select the collation setting when you install SQL Server 2005 Express Edition SP1, see the following Microsoft SQL Server 2005 Books Online topics:
How to Install SQL Server Express
Collation Settings (SQL Server Express)
Collation Settings (SQL Server Express)
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
932593 FIX: You receive an error message when you try to install the original release version of SQL Server 2005 or SQL Server 2005 Service Pack 1 on a computer that is running Windows Vista
Article ID: 929105 - Last Review: 12/09/2015 08:31:54 - Revision: 2.3
Windows Vista Business, Windows Vista Enterprise, Windows Vista Ultimate, Microsoft SQL Server 2005 Express Edition, Microsoft SQL Server 2005 Service Pack 1
- kbnosurvey kbarchive kbharmony kbpending kbbug kbexpertiseinter kbtshoot KB929105