Database Preinstallation Tasks for Infor Landmark Technology

The databases for your Environment data (the GEN product line) will be configured by the installation program based on answers you gave during installation. Before you install the Microsoft SQL Server database or Infor Landmark Technology, perform the following tasks and collect the information shown in this section.

Perform this task Collect this information

Determine the database server name

The database name or some alias (as set in the SQL Server Configuration Manager) is mapped to the DBSERVER parameter in the %LARUNDIR%\DATAAREA\db.cfg database interface configuration file.

 The Microsoft SQL Server name or alias.

Determine the database name

The name of the database is mapped to DBNAME in the %LARUNDIR%\DATAAREA\db.cfg database interface configuration file. The default is the product line name that you are running against (for example, GEN or your application product line).

 The database name within the server.

Determine database user name (ID) and password

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

    These values are mapped to the LOGINNAME and PASSWORD parameters in the %LARUNDIR%\DATAAREA\db.cfg database interface 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 to use for Landmark data or let Microsoft SQL Server determine file groups for you. Your answer to this response is mapped to the FILEGROUPS parameter in the %LARUNDIR%\DATAAREA\db.cfg database interface 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.

What Is an Instance?

If you want to create the file groups rather than letting Microsoft SQL Server create them, record these values:

  • Index file group name.

  • Application data file group name.

  • Large object file group name.
Determine whether the database will support Unicode, and record the character set chosen for the database.

  • Unicode, yes or no?

  • Character set