Unable to determine system default collation

[ken]

Dear all,
I failed to install msde sp3a in xp pro. It popped up
something in the installation process, it says "Unable to
determine system default collation". What does it mean? Thx

[Bart Duncan [MSFT]]

Ken,

WinXP and Windows Server 2003 shipped with several new Windows locales
that MSDE setup doesn't know about. If the system default locale is one
of these new locales, MSDE setup fails to find the proper SQL collation
to use because it doesn't have locale --> collation mappings for these
locales:

Language - Country/Region LCID (hex)
--------------------------------------------- ------------
Kyrgyz (Cyrillic) - Republic of Kyrgyzstan 440
Uzbek (Latin) - Republic of Uzbekistan 443
Tatar - Tatarstan 444
Punjabi(Gurmukhi) - India 446
Gujarati - India 447
Tamil - India 449
Mongolian (Cyrillic) - Mongolia 450
Galician - Spain 456
Konkani - India 457
Uzbek (Cyrillic) - Republic of Uzbekistan 843
Armenian - Republic of Armenia 042b
Azeri (Latin) - Azerbaijan 042c
Kazakh - Kazakstan 043f
Telugu - India 044a
Kannada - India 044b
Marathi - India 044e
Sanskrit - India 044f
Syriac - Syria 045a
Azeri (Cyrillic) - Azerbaijan 082c
Chinese - Hong Kong 0c04
Spanish - Colombia 240a

If your machine is using one of these locales as the system default
locale, use one of the following approaches to work around the problem:

1. Change the system default locale to one of the ones listed in
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/i
n_collation_6gfn.asp?frame=true to do the install. You can change the
locale back once MSDE is installed (note that you may have to change it
back to one of the known locales to uninstall).

2. Add a command line parameter of "COLLATION=Latin1_General_CI_AS"
(specify whatever collation name you want if you prefer not to use
Latin1_General_CI_AS).

Bart
------------
Bart Duncan
Microsoft SQL Server Support

Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no
rights.

--------------------
Content-Class: urn:content-classes:message
From: "ken" <anon...@discussions.microsoft.com>
Sender: "ken" <anon...@discussions.microsoft.com>
Subject: Unable to determine system default collation
Date: Fri, 19 Dec 2003 20:41:14 -0800
Lines: 4
Message-ID: <08ea01c3c6b3$7fcf17f0$a301...@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcPGs3/Ph+LVQd+rSKCI1C3tRbwItQ==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.sqlserver.msde
Path: cpmsftngxa07.phx.gbl
Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.msde:10939
NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
X-Tomcat-NG: microsoft.public.sqlserver.msde