Database Preinstallation Tasks

Your databases are configured by the installation programs, based on answers you gave during installation. Before you install the Microsoft SQL Server database, Infor Lawson System Foundation, or Lawson applications, perform the following tasks and collect the information shown in this section.

Perform this task Collect this information

Add environment variables and required values to the %PATH% variable.

The choices you see in the installation program depend on what the installation program detects in the %PATH% variable on the Lawson server machine.

  1. Define an environment variable for the %MSSQL_HOME% directory.

    %MSSQL_HOME% must be defined as the directory where Microsoft SQL Server is installed.

For information and instructions, see the documentation provided with the database and/or the operating system.

The installation location of the GEN, LOGAN, and application databases.

The %MSSQL_HOME% directory path for each instance.

Determine the initial number of simultaneous database connections

The installation program asks for the number of simultaneous database connections that you allow. A database connection is one driver job, or one open data area for each running program.

The default value is 500; you may need to increase this value significantly. Use this value to calculate the starting values of the USERS, FOREIGN, and IFILES parameters in the Lawson ladb.cfg file. Individually tune these values as required after installation.

The number of simultaneous database connections.

Determine the database server name and database name

You can install separate components (GEN, LOGAN, or application product lines) to distinct databases. The database name for each product line must be entered during installation.

The name of the Lawson server machine where the Microsoft SQL Server is installed is mapped to the DBSERVER parameter in the MICROSOFT database driver configuration file.

The name of the database is mapped to DBNAME in the MICROSOFT database driver configuration file. The default is the product line name that you are running against (for example, GEN or LOGAN).

The database server name for each product line.

The database name within the server for each product.

Determine database user name (ID) and password

  • The login name (user name) and password for the database user who accesses Lawson data at run-time.

    These values are mapped to the LOGINNAME and PASSWORD parameters in the MICROSOFT database driver configuration file.

 The login name and password for the database user.

Determine how to configure Microsoft SQL Server file groups

Determine whether you want to specify the file groups or let Microsoft SQL Server determine file groups for you. Your answer to this response is mapped to the FILEGROUPS parameter in the MICROSOFT database driver configuration file.

If you specify the file groups yourself, the installation program asks for the name(s) that you entered in Microsoft SQL Server.

Note: The names you enter must exactly match the names specified in when creating the database spaces for the file groups. File group names are case-sensitive.
If you want to create the file groups rather than letting Microsoft SQL Server create them, record the index and data file group name for each product line.