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

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• Clarity PPM SaaS
• 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