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

Document ID : KB000051168
Last Modified Date : 14/02/2018
Show Technical Document Details

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.