Article ID: 929105 - View products that this article applies to.
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 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:
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)
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/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: October 30, 2007 - Revision: 2.3