Clarity: How to Create a Database for Microsoft SQL Server 2005.

book

Article ID: 51168

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

Description:

Steps to correctly create a SQL Server database for use with Clarity PPM.

Solution:

Please follow these steps to correctly create the database:

  1. Navigate to Start -> Programs -> Microsoft SQL Server -> SQL Server Studio Manager.

  2. Login using 'sa' account

  3. Right Click on Databases and select 'New Database'

  4. The required collation setting for Clarity PPM is "SQL_Latin1_General_CP1_CI_AS", this must be applied at the database and server level.

  5. Enter desired database name and click 'OK'

  6. Click on 'New Query' tab.

  7. Modify the following queries to use your database name. <'DB_NAME' = database name created in step 3.>

    ALTER DATABASE 'DB_NAME'
    SET READ_COMMITTED_SNAPSHOT ON

    ALTER DATABASE 'DB_NAME'
    SET ALLOW_SNAPSHOT_ISOLATION ON;

    ALTER DATABASE 'DB_NAME'
    SET ARITHABORT ON;

    EXEC SP_DBCMPTLEVEL 'DB_NAME', 90;
    ALTER DATABASE 'DB_NAME'
    SET ANSI_NULLS ON

    USE MASTER
    SP_ADDLOGIN @LOGINAME = 'NIKU', @PASSWD = 'YOUR PASSWORD'
    , @DEFDB = 'DB_NAME'
    , @DEFLANGUAGE = 'US_ENGLISH'
    GO

    USE MASTER
    GRANT VIEW SERVER STATE TO NIKU
    SP_GRANTDBACCESS @LOGINAME = 'NIKU', @NAME_IN_DB = 'NIKU'
    SP_ADDROLEMEMBER @ROLENAME = 'DB_OWNER', @MEMBERNAME = 'NIKU'
    ALTER USER NIKU WITH DEFAULT_SCHEMA = NIKU
    GO

    USE 'DB_NAME'
    CREATE USER NIKU
    FOR LOGIN NIKU
    WITH DEFAULT_SCHEMA = NIKU
    GO

  8. Once these steps are complete you can proceed with the database installation in the NSA.

Keywords: CLARITYKB, configuration, installation, implementation.

Environment

Release:
Component: PPMENV