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 below for installation in Cluster Mode.

Java installation

This section is dedicated to the installation of Java on the Application Server:

1. Download the Java Runtime Environment ver. 1.6.0_24

2. Set the environment variable JAVA_HOME with the installation folder of Java package just installed

For instructions on how to set environment variables, see: http://technet.microsoft.com/it-it/library/cc736637(WS.10).aspx