RE: Yet another SQL Express SP2 on Vista Problem...
- From: petery@xxxxxxxxxxxxxxxxxxxx ("Peter YangMSFT]")
- Date: Mon, 11 Jun 2007 03:16:10 GMT
Hello Tony,
Based on my research, this issue might be caused by a known issue in Vista
where computer name retrival API has changed behaviour. This might be a
problem on Vista if case sensitive collation is chosen and Windows computer
name includes lower case characters. 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.
Possible workarounds:
1. Change the computer name with upper case.
Since Vista does not allow to change a computer name to the same name with
only case difference, this workaround requires two steps, changing to the
different name first (ComputerName to ComputerNameX for example) and then
changing to the original name with upper case (ComputerNameX ->
COMPUTERNAME).
2. Change the collation that the customer's product uses from case
sensitive (including binary) to case insensitive.
You may want to check the following article for more details:
929105 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"
http://support.microsoft.com/default.aspx?scid=kb;EN-US;929105
If you have any feedback or wishes on SQL Server, please submit via the
link below and our product team would like to hear your voice:
http://connect.microsoft.com/SQLServer/feedback/
If anything is unclear or you have any comments, please feel free to let's
know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
.
- Follow-Ups:
- References:
- Prev by Date: RE: SQL-Server Licensing and Web Apps?
- Next by Date: Re: SQL Server 2005 Express SP2 Install Error
- Previous by thread: Yet another SQL Express SP2 on Vista Problem...
- Next by thread: Re: Yet another SQL Express SP2 on Vista Problem...
- Index(es):
Relevant Pages
|
