Microsoft KB Archive/929105
Article ID: 929105
Article Last Modified on 10/30/2007
- Windows Vista Business
- Windows Vista Enterprise
- Windows Vista Ultimate
- Microsoft SQL Server 2005 Express Edition
- Microsoft SQL Server 2005 Service Pack 1
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:
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.
To work around this problem, use one of the following methods.
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:
- Click Start, right-click Computer, and then click Properties.
- Under Computer name, domain, and workgroup settings, click Change settings.
- 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 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
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
Keywords: kbtshoot kbbug kbpending kbexpertiseinter KB929105