Description:
Steps to correctly create a SQL Server database for use with Clarity PPM.
Solution:
Please follow these steps to correctly create the database:
- Navigate to Start -> Programs -> Microsoft SQL Server -> SQL Server Studio Manager.
- Login using 'sa' account
- Right Click on Databases and select 'New Database'
- The required collation setting for Clarity PPM is "SQL_Latin1_General_CP1_CI_AS", this must be applied at the database and server level.
- Enter desired database name and click 'OK'
- Click on 'New Query' tab.
- 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
- Once these steps are complete you can proceed with the database installation in the NSA.
Keywords: CLARITYKB, configuration, installation, implementation.