[6] SQL Server 2005 configuration for Clarity

SQL Server 2005 Database configuration for Clarity :-

1. Login as sa
2. [ For 8.1 and below only ] Databases > New Database > Database Name : Niku > Options > Compatibility Level : SQL Server 2000 (80) ( Check installation Guide to confirm compatibility level for the version being installed )
3. Security > Create Login > niku ( Select SQL Server Login and give niku password )
4. Database > Niku > Security > Users > Create User > user Name : niku ; Login : niku
5. Database > Niku > Security > Schema > Create Schema > Schema Name : niku ; Schema Owner : niku
6. Security > Logins > Niku > Properties > User Mapping > Select Niku database Row > For Niku Database change 'Default Schema' to niku > In Below Pane check the role membership for 'db_owner'. 7. In Master database execute following commands :
ALTER DATABASE niku SET ARITHABORT ON
ALTER DATABASE niku SET ANSI_NULLS ON
ALTER DATABASE niku SET QUOTED_IDENTIFIER ON
ALTER DATABASE niku SET READ_COMMITTED_SNAPSHOT ON
GRANT VIEW SERVER STATE to niku

8. Install database from Clarity NSA.

* If you are restoring SQL Server database from Backup then run following command to fix niku login. (If there are more database users repeat this command for each user)

sp_change_users_login 'Auto_fix' , 'niku'