Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 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

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

View products that this article applies to.

Bug #: 469913 (SQL Server 8.0)

↑ Back to the top

Symptoms

When you try to install Microsoft SQL Server Desktop Engine (Windows) or SQL Server Desktop Engine (also known as MSDE 2000) Service Pack 2 (SP2) or later on a computer that has an operating system locale that does not have a default SQL Server collation mapping, the Setup program may fail. You may receive the following error message:
Unable to determine system default collation.
Note If you run the Setup program and you use the /qn command-line switch to suppress messages that are displayed while the Setup program is running, you may not receive this message.

If you enable verbose logging when you run the Setup program, an error message that is similar to the following may be logged in the setup log file:
Starting custom action UseDefaultCollation
Unable to determine system default collation.
MSI (s) (7C!24): Product: Microsoft SQL Server Desktop Engine -- Unable to determine system default collation.
Action ended 11:28:49: UseDefaultCollation.2D02443E_7002_4C0B_ABC9_EAB2C064397B. Return value 3.
Note You can enable verbose logging while the Setup program is running by using the /L*v switch. To do so, run the following command-line statement:
setup.exe /L*v Setup Log File Path

↑ Back to the top

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 and SQL Server Desktop Engine (Windows). The following locales are not supported by SQL Server 2000 collation mappings:
Collapse this tableExpand this table
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

When you run the Setup.exe file that is included in the 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 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 previous command assumes that the .ini file is in the same folder as the Setup.exe file.

For more information about the SQL Server Desktop Engine Setup program, visit the following Microsoft Web site:
http://msdn2.microsoft.com/en-us/library/aa214935(SQL.80).aspx

↑ Back to the top

References

For more information about Windows Collation Designators, visit the following Microsoft Web site:
http://msdn2.microsoft.com/en-us/library/aa176553(SQL.80).aspx
For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
308866� FIX: SQL Server 2000 Setup terminates unexpectedly if you install Chinese (Hong Kong) locale
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
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)

↑ Back to the top

Keywords: KB838302, kbmessagebox, kbcommandline, kberrmsg, kbsetup, kbbug

↑ Back to the top

Article Info
Article ID : 838302
Revision : 7
Created on : 3/19/2007
Published on : 3/19/2007
Exists online : False
Views : 486