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 (823466)


The information in this article applies to:

  • Microsoft SQL Server 2000 Desktop Engine (MSDE)
  • Microsoft SQL Server 2000 Desktop Engine (MSDE) SP1
  • 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
  • MSN Partner BYOA

SYMPTOMS

When you install Microsoft SQL Server 2000 Desktop Engine (also known as MSDE 2000) on a computer that has an operating system locale that does not have a default SQL Server collation mapping, the Setup program may fail and close without any visible warning. If you enable verbose logging when you set up SQL Server Desktop Engine, an error message that is similar to the following may be logged in the setup log file:
Starting custom action UseDefaultCollation Action ended
18:38:05:
UseDefaultCollation.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
Return value 3.
This problem occurs in the original release version of SQL Server Desktop Engine and in SQL Server Desktop Engine Service Pack 1 (SP1).

Note To enable verbose logging while the Setup program is running, use the /L*v command-line switch. To do so, run the following command-line statement:
setup.exe /L*v Setup Log File Path

RESOLUTION

To resolve this problem, install the latest SQL Server Desktop Engine service pack. For additional information about how to obtain the latest SQL Server 2000 service pack, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to obtain the latest SQL Server 2000 service pack

Note The latest service pack may not permit the SQL Server Desktop Engine Setup program to successfully complete. You may receive the following error message:
Unable to determine system default collation.

MORE INFORMATION

Microsoft Windows XP and Microsoft Windows Server 2003 include several new Windows locales that are not supported by the SQL Server 2000 collation mappings. Additionally, these Windows locales are not supported by SQL Server Desktop Engine. The following locales 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

Set up verbose logging

If you use the Setup.exe file that is included in the SQL Server Desktop Engine Setup program to install SQL Server Desktop Engine, you can enable verbose logging for troubleshooting purposes by using the L*v command-line switch. The following sample command enables verbose logging:
D:\MSDE2000\>setup.exe /settings setup.ini D:\MSDE2000\setup.ini /L*v C:\MSDE_setup.log
Note In this sample command, a Setup.ini file that contains the settings for the TARGETDIR argument, the DATADIR argument, the INSTANCENAME argument, and the COLLATION argument is specified. If you specify the /settings option, you set these options in the .ini file, not in the command-line arguments. The sample command assumes that the .ini file is in the same folder as the Setup.exe file.

REFERENCES

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

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 additional information about a similar problem in the SQL Server 2000 Setup program, click the following article number to view the article in the Microsoft Knowledge Base:

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

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

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

838303 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)

Modification Type:MinorLast Reviewed:10/3/2006
Keywords:kbMSNQwestPortal kbMessageBox kbDatabase kbCommandLine kbwizard kbSysAdmin kbbug KB823466 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.