Error message when you install SQL Server 2005 Express Edition Service Pack 1 in Windows Vista: Windows NT user or group lt;COMPUTERNAME gt; SQLServer2005MSSQLUser$ lt;COMPUTERNAME gt;$MSSQLSERVER not found

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

Article ID : 929105
Last Review : October 30, 2007
Revision : 2.1
On This Page

SYMPTOMS

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.

Back to the top

CAUSE

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 uses the following two methods to return the computer name in response to a request for the computer name:

• 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.

During one part of the installation of SQL Server 2005 Express Edition, the Setup program requests the computer name as mixed characters. However, Windows Vista returns the computer name in uppercase characters instead. The Setup program also requests the computer name in other parts of the installation of SQL Server 2005 Express Edition. Windows Vista may then return the computer name in mixed case characters.

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.

Back to the top

WORKAROUND

To work around this problem, use one of the following methods.

Back to the top

Method 1: Change the computer name to use only uppercase characters

A 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:

1. Click StartStart, right-click Computer, and then click Properties.
2. Under Computer name, domain, and workgroup settings, click Change settings.

User If you are prompted for an administrator password or for a confirmation, type your password, or click Continue.

3. In the System Properties dialog box, click Change.
4. 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.
5. 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.

6. When you are prompted to restart the computer to apply the changes, click OK, click Close, and then click Restart Now.
7. 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.
8. Install SQL Server 2005 Express Edition SP1.

Back to the top

Method 2: Use a case-insensitive collation setting for the SQL Server service

When 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

http://msdn2.microsoft.com/en-us/library/ms143722.aspx (http://msdn2.microsoft.com/en-us/library/ms143722.aspx)

Collation Settings (SQL Server Express)

http://msdn2.microsoft.com/en-us/library/ms143311.aspx (http://msdn2.microsoft.com/en-us/library/ms143311.aspx)

Back to the top

REFERENCES

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

932593 (/Feedback.aspx?kbNumber=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

Back to the top


APPLIES TO
• Windows Vista Business
• Windows Vista Enterprise
• Windows Vista Ultimate
• Microsoft SQL Server 2005 Express Edition
• Microsoft SQL Server 2005 Service Pack 1

Back to the top

Keywords: 
kbtshoot kbbug kbpending kbexpertiseinter KB929105

Back to the top

 

Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
Microsoft Corporation. All rights reserved. Terms of Use | Trademarks


You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button

Leave a Reply

*
To prove that you're not a bot, enter this code
Anti-Spam Image