Database Installation and Configuration Requirements

This document provides guidelines and requirements for configuring the database to work with the Lawson system.

Caution: 

Lawson does not provide instructions for installing Microsoft SQL Server products; installing the database is the responsibility of the customer. Lawson cannot assume any responsibility for the results of an improper installation. Use the documentation provided with the Microsoft SQL Server database for installation instructions.

Database Settings

  • Microsoft SQL Server Sort Order setting of Binary Order.

    Landmark Landmark with Infor Lawson System Foundation
    Sort order (collation)

    Latin1_General_BIN

    Latin1_General_BIN2

    		 Latin1_General_BIN

    To verify that the database Sort Order is set to Binary order, use the Microsoft SQL Server command sp_helpsort.

    Implementing Unicode Support

Database Support for the Text Search Feature

To enable the text search feature, you must download, install and configure the Microsoft Full Text Search filters. For more information, see the MSDN library article Full-Text Search, found at http://msdn2.microsoft.com/en-us/library/ms142571.aspx.

For more detailed information on text search setup and configuration, see Implementing Text Indexing and Text Searches.