How to: Change Operating System Settings to Support Localized Versions
Localized versions of Microsoft SQL Server 2005 are supported on English-language versions of supported operating systems through the use of Microsoft Windows Multilingual User Interface Pack (MUI) settings.
However, you must verify certain operating system settings before installing a localized version of SQL Server 2005 on a server that is running an English-language operating system with a non-English MUI setting. You need to verify that the following operating system settings match the language of the localized SQL Server to be installed:
- The operating system user interface setting
- The operating system user locale setting
- The system locale setting
If the settings do not match the language of the localized SQL Server to be installed, then use the following procedures to correctly set these operating system settings.
Warning
Installations of different language versions of SQL Server instances on the same computer are NOT supported. Example: German SQL Server 2005 and Portuguese (Brazil) SQL Server 2005 are NOT supported as multiple instances on the same computer.
To change the operating system user interface setting
If not already installed, install the operating system MUI that matches your localized version of SQL Server 2005.
In Control Panel, open Regional and Language Options.
On the Languages tab, for Language used in menus and dialogs, select a value from the list.
This setting will affect the user interface language of SQL Server 2005, so it must match your localized version of SQL Server 2005.
Click Apply to confirm the change, and OK to close the window.
To change the operating system user locale setting
If not already installed, install the operating system MUI that matches your localized version of SQL Server 2005.
In Control Panel, open Regional and Language Options.
On the Regional Options tab, for Select an item to match its preferences, select a value from the list.
This setting will affect culture-specific data formatting.
Click Apply to confirm the change, and OK to close the window.
To change the system locale setting
If not already installed, install the operating system MUI that matches your localized version of SQL Server 2005.
In Control Panel, open Regional and Language Options.
On the Advanced tab, for Select a language to match the language version of the non-Unicode programs you want to use, select a value from the list.
This setting will allow SQL Server Setup to choose the best default collation for your SQL Server 2005 installation.
Click Apply to confirm the change, and OK to close the window.
See Also
Reference
Collation Options and International Support
Hardware and Software Requirements for Installing SQL Server 2005
Other Resources
SQL Server 2005 Preparation How-to Topics