Collation in Service Manager
Service Manager doesn't like the default collation method (SQL_Latin1_General_CP1_CI_AS). If your SCSM SQL server is running with that collation mode you will get a warning when you install SCSM.
Caution |
If you continue Setup using the default collation (SQL_Latin1_General_CP1_CI_AS), you will not be able to support multiple languages in Service Manager. In the future, if you decide you want to support multiple languages, you will have to re-install SQL Server. |
The collations in the following table represent the approved collations that were tested.
Windows Locale |
LCID |
Collation |
English |
0x409 |
Latin1_General_100_CI_AS |
Chinese_Taiwan |
0x404 |
Chinese_Traditional_Stroke_Count_100_CI_AS |
Chinese_PRC |
0x804 |
Chinese_Simplifies_Pinyin_100_CI_AS |
French |
0x40C |
French_100_CI_AS |
German_Standard |
0x407 |
Latin1_General_100_CI_AS |
Italian_Standard |
0x410 |
Latin1_General_100_CI_AS |
Japanese |
0x411 |
Japanese_XJIS_100_CI_AS |
Korean |
0x412 |
Korean_100_CI_AS |
Portuguese_Brazilian |
0x416 |
Latin1_General_100_CI_AS |
Russian |
0x419 |
Cyrillic_General_100_CI_AS |
Spanish_Modern_Sort |
0xC0A |
Modern_Spanish_100_CI_AS |