Microsoft SQL Server

To install the Microsoft SQL Server (MSQL) software, use the SQL Server Installation Manuals. This section provides guidelines for a correct setup of SQL Server for Infor LN. For SQL Server database tuning advice, see Infor LN Performance, Tracing and Tuning Guide for SQL Server

Collation settings

During the installation process of SQL Server the Server configuration dialog box is displayed. On this dialog box you can select a collation, code page and sort order.

Collations provide sorting rules, case, and accent sensitivity properties for your data. Collations that are used with character data types such as char and varchar dictate the code page and corresponding characters that can be represented for that data type.

The collation of the LN database is set by the Installation Wizard during the database creation process.

Before selecting the collation and sorting rules during the SQL Server installation, you must decide which applications you want to run using this SQL Server instance. Investigate if these applications have pre-requisites about the instance collation.

Select the correct collation and sorting rules during the SQL Server installation. Changing the collation after you installed the SQL Server means rebuilding your database and reloading the data.

The LN database on the SQL server requires a "Windows collation designator and sort order", you can select this on the Collation selection dialog box.

Unicode

In case of a Unicode installation select Latin1_General_100_CS_AS_KS_WS and these sort order characteristics:

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

Data storage

This table shows a rough starting value for the size of the SQL Server table spaces. Consider the requirements based on your system sizing for optimal performance.

Tablespace Initial size
Log 2 GB
Data + Index Refer to sizing, minimal 20 GB
When using auto growth, use large chunks of 2 GB or more to minimize fragmentation.

Remote database (3-tier)

To install the database on another server, you must Install SQL Server client on the application server. For more information, refer to the SQL Server Books Online.