ItmSUITE® - SM/PM installation

DB: creation and initialization

Please perform the following steps:

1. Create new SM / PM database (use a DB role with grants to perform this).

2. From SM / PM installation package open Config/Scripts/Create_MSSQL.sql script, select SM / PM database and run the script.

3. From SM / PM installation package open Config/Scripts/Recreate_PSM_views.sql script, select SM / PM database and run the script (ignore the error messages related to failed attempt to delete not present views).

4. From SM / PM installation package open Config/Scripts/Create_MSSQL.sql script, remove part of script about table creation (from beginning to 'alter table') and select SM / PM database, Run the script.

5. From SM / PM installation package open Config/Scripts/Init_MSSQL.sql script, select SM / PM database and run the script.

Application server installation

Single mode

The default installation mode of SM / PM is in "Single Mode". The following paragraphs will explain this mode, otherwise see section Cluster Mode for installation in "Cluster Mode".