BUG: You receive an "Unable to determine system default collation" error message when you try to remove Microsoft SQL Server 2000 Desktop Engine or Microsoft SQL Server 2000 Desktop Engine (Windows) (838303)


The information in this article applies to:

  • Microsoft SQL Server 2000 Desktop Engine (Windows), when used with:
    • Microsoft Windows Server 2003, Datacenter Edition
    • Microsoft Windows Server 2003, Enterprise Edition
    • Microsoft Windows Server 2003, Standard Edition
  • Microsoft SQL Server 2000 Desktop Engine (MSDE), when used with:
    • Microsoft Windows Server 2003, Datacenter Edition
    • Microsoft Windows Server 2003, Enterprise Edition
    • Microsoft Windows Server 2003, Standard Edition
    • Microsoft Windows Server 2003, Web Edition
    • the operating system: Microsoft Windows XP
  • Microsoft SQL Server 2000 Desktop Engine (MSDE) SP1, when used with:
    • Microsoft Windows Server 2003, Datacenter Edition
    • Microsoft Windows Server 2003, Enterprise Edition
    • Microsoft Windows Server 2003, Standard Edition
    • Microsoft Windows Server 2003, Web Edition
    • the operating system: Microsoft Windows XP
  • Microsoft SQL Server 2000 Desktop Engine (MSDE) SP2, when used with:
    • Microsoft Windows Server 2003, Datacenter Edition
    • Microsoft Windows Server 2003, Enterprise Edition
    • Microsoft Windows Server 2003, Standard Edition
    • Microsoft Windows Server 2003, Web Edition
    • the operating system: Microsoft Windows XP
  • Microsoft SQL Server 2000 Desktop Engine (MSDE) SP3, when used with:
    • Microsoft Windows Server 2003, Datacenter Edition
    • Microsoft Windows Server 2003, Enterprise Edition
    • Microsoft Windows Server 2003, Standard Edition
    • Microsoft Windows Server 2003, Web Edition
    • the operating system: Microsoft Windows XP
  • Microsoft SQL Server 2000 Desktop Engine (MSDE) SP3a, when used with:
    • Microsoft Windows Server 2003, Datacenter Edition
    • Microsoft Windows Server 2003, Enterprise Edition
    • Microsoft Windows Server 2003, Standard Edition
    • Microsoft Windows Server 2003, Web Edition
    • the operating system: Microsoft Windows XP
Bug #: 469913 (SQL Server 8.0)

SQL Server 8.0:469913

SYMPTOMS

When you try to remove Microsoft SQL Server 2000 Desktop Engine or Microsoft SQL Server 2000 Desktop Engine (Windows) from your computer, the Setup program may fail, and you may receive the following error messages.

Error message 1

Unable to determine system default collation.


Error message 2

Fatal error during installation.


This problem may occur when one of the following conditions is true:
  • You remove SQL Server 2000 Desktop Engine or SQL Server 2000 Desktop Engine (Windows) on a computer that has an operating system locale that does not have a default SQL Server collation mapping.
  • You remove SQL Server 2000 Desktop Engine or SQL Server 2000 Desktop Engine (Windows) after the regional setting is changed to an operating system locale that does not have a default SQL Server collation mapping.
  • You remove an instance of SQL Server 2000 Desktop Engine or SQL Server 2000 Desktop Engine (Windows) that was installed by specifying a collation mapping by using the COLLATION switch on a computer that has an operating system locale that does not have a default SQL Server collation mapping.

MORE INFORMATION

Microsoft Windows XP and Microsoft Windows Server 2003 include several new Windows locales that are not supported by the Microsoft SQL Server 2000 collation mappings. Additionally, these Windows locales are not supported by SQL Server 2000 Desktop Engine and SQL Server 2000 Desktop Engine (Windows). The locales in the following table are not supported by SQL Server 2000 collation mappings:

LanguageCountry/RegionLCID (hexadecimal)
Kyrgyz (Cyrillic)Republic of Kyrgyzstan440
Uzbek (Latin)Republic of Uzbekistan443
TatarTatarstan444
Punjabi(Gurmukhi)India446
GujaratiIndia447
TamilIndia449
Mongolian (Cyrillic)Mongolia450
GalicianSpain456
KonkaniIndia457
Uzbek (Cyrillic)Republic of Uzbekistan843
ArmenianRepublic of Armenia042b
Azeri (Latin)Azerbaijan042c
KazakhKazakstan043f
TeluguIndia044a
KannadaIndia044b
MarathiIndia044e
SanskritIndia044f
SyriacSyria045a
Azeri (Cyrillic)Azerbaijan082c
ChineseHong Kong0c04
SpanishColombia240a

REFERENCES

For additional information about related problems with operating system locales, click the following article numbers to view the articles in the Microsoft Knowledge Base:

823466 BUG: You cannot install SQL Server Desktop Engine on a computer that has an operating system locale that does not have a default SQL Server collation mapping


838302 BUG: You may receive an error message when you try to install SQL Server Desktop Engine (Windows) or SQL Server Desktop Engine SP2 or later


308866 FIX: SQL Server 2000 setup terminates unexpectedly if you install Chinese (Hong Kong) locale



For more information about Windows Collation Designators, visit the following Microsoft Web site:

http://msdn.microsoft.com/library/en-us/instsql/in_collation_6gfn.asp



For more information about the SQL Server Desktop Engine Setup program, visit the following Microsoft Web site:

http://msdn.microsoft.com/library/en-us/distsql/distsql_84xl.asp

Modification Type:MajorLast Reviewed:4/20/2004
Keywords:kbsetup kberrmsg KB838303 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.