Category:CPM 7.5 INSTALL ORACLE

Configuring the SQL Server Database

Please verify that you have the correct version of Microsoft SQL Server installed and properly configured. The CPM 7.5 release requires SQL Server 2005 SP2.

1. Restore Pre-built Database

2. Clear security with the clear-sysconfig and grant privilages script (located on the CD in the \Database Installation Scripts\SQL directory)

3. Create appmaster user and grant it everything

4. Run password tool and use appmaster to log on

5. Create ADM procedures using new create_procedure_sql_ipath_administrators.sql and create_procedure_sql_ipath_dropadministrators.sql (located on the CD in the \Database Installation Scripts\SQL directory).

6. Drop ADM user by running exec sql_ipath_dropadministrator

7. Create ADM user by running exec spl_ipath_administrator

8. Remove the spl_ipath_administrator stored procedure from the database (for security reasons).