Microsoft SQL Server

To install the Microsoft SQL (MSQL) software, use the MSQL Installation Manuals.

Belangrijk!
  • Documents with the latest (version) information about the database:
    Infor Enterprise Server - Technical Notes
  • Infor Enterprise Server - Technical Notes for Porting Set x.x
Overview of the installation process

Microsoft SQL Server installations are version-dependant and systemdependant. Check your Microsoft SQL Server documentation for the specific installation procedure of the SQL version you want to install.

  • Online Help is available on the SQL Server Setup windows.
Specific LN Note

If during the installation process of SQL the Collation Settings dialog box appears, select Collation designator and sort order together with the Binary check box to specify a binary sort order:

However, in case of a Unicode install, select the following:

  • Collation designator and sort order.

    Together with:

    • Case - sensitive
    • Accent - sensitive
    • Kana - sensitive
    • Width - sensitive

Collation Settings

NB

The binary sort/collation only applies for native mode installations and not for unicode mode installations.

A sort order is a set of rules that determines how SQL Server assembles and presents data in response to database queries. Select the correct sort order during the installation of SQL Server. If you have to change sort orders after you install the SQL Server, rebuild your databases and reload your data.

NB

Select Windows collation designator and sort order with Latin1_General as the collation designator. Make sure you also select the Binary check box and not the Binary-code point checkbox.

Locale and collation setting for Multi-byte (not Unicode) environments.

To store native multi-byte (not Unicode) characters in a SQL-Server database, the SQL server collation, the Windows system and the locale of the LN environment must be compatible with eachother.

For example, when the used multi-byte language is SHIFTJIS, the system locale must be Japanese (Japan). To change the system locale, use the “Regional and Language” settings, Administrative tab -> Change system locale.

The settings can differ for other Windows versions. The collation of the SQL server database must be setup at creation time of the database, or SQL server instance.

In the following list the LN locale, the O.S. locale and the SQL-Server collation which are compatible with eachother.

LN localeWindows system localeSQL-Server collation
SHIFTJIS_WIN32Japanese (Japan)Japanese_BIN
GB_WIN32Chinese (SIMPLIFIED, PRC)Chinese_PRC_BIN
BIG5_WIN32Chinese (Traditional, Taiwan)Chinese_Taiwan_Stroke_BIN
KOREAN_WIN32Korean (Korea)Korean_Wansung_BIN

 

NB

Note the binary sort order of each SQL server collation. Newer SQL versions also support _BIN2.

If all required SQL software is installed and configured, you are ready to start the Staging Wizard. For more information, refer to the Overall installation guide for Infor LN products (U9498 US).