RE: unable to determine system default collation (Installation Failed)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bart Duncan [MSFT] (bartd_at_online.microsoft.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 00:30:44 GMT

See if http://support.microsoft.com/?id=823466 applies. If so, there are
two workarounds: (1) change you system default locale to something else,
or (2) use the COLLATION command line parameter to specify a particular
collation to use so that setup doesn't have to try to determine which
collation to use based on your system locale.

HTH,
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: "Patrick Cohen" <anonymous@discussions.microsoft.com>
Sender: "Patrick Cohen" <anonymous@discussions.microsoft.com>
Subject: unable to determine system default collation (Installation
Failed)
Date: Mon, 22 Mar 2004 18:47:59 -0800
Lines: 8
Message-ID: <d17c01c41081$40721360$a001280a@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
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcQQgUByVOOdsM2WRniP2MiUErDkvA==
Newsgroups: microsoft.public.sqlserver.msde
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.msde:13209
NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
X-Tomcat-NG: microsoft.public.sqlserver.msde

Hi, I've been installing MSDE on my WinXP Pro PC, without
any difficulties. However, I've got this error when I
formatted my PC and install MSDE again: unable to
determine system default collation...

Could anyone please give me some assistance? Thanks in
advance.

Relevant Pages

  • Re: Moving Servers, Matching Collation
    ... If you change your default locale to U.S., that will be sufficient to have ... setup default to SQL_Latin1_General_CP1_CI_AS just as you say. ... When you reach the "Collation Settings" dialog, ... Microsoft SQL Server Support ...
    (microsoft.public.sqlserver.setup)
  • RE: Cannot determine default collation
    ... You can avoid the problem by changing your default system ... locale to a locale that isn't in the list in that article, reboot, then ... COLLATION command line parameter to setup (e.g. ... thread-index: AcRS8jxBIFmv0lEuTbeceZiciXUOYg== ...
    (microsoft.public.sqlserver.msde)
  • RE: unable to determine default collation
    ... You can avoid the problem by changing your default system ... locale to a locale that isn't in the list in that article, reboot, then ... COLLATION command line parameter to setup. ... thread-index: AcRS9OOXTYpyph85RCClAuJvdqXOgA== ...
    (microsoft.public.sqlserver.server)
  • Re: Alphabetical sorts
    ... Collation is almost always locale dependant. ... One day I needed collation that worked on Windows and Linux. ... '''Grab character encoding from locale name''' ... def setup_locale: ...
    (comp.lang.python)
  • Re: Collation
    ... Please reply to the newsgroup only - thanks. ... Thread-Topic: Collation ... They are populated by customers. ... > external to your database should help. ...
    (microsoft.public.sqlserver.programming)