How to fix permission in SQL Server - CA PPM

Article Id: 33325
Status: Published
Updated On: 21-03-2018 07:12
Legacy Id: TEC1190294
Products:
CLARITY PPM FOR ITG , CA Project & Portfolio Management , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , STARTER PACK-CLARITY PPM
Issue/Introduction:

Question:

How to associate the restore database to my MS SQL Server user? I can’t create a new object in CA Clarity

Answer: 

After restored CA Clarity Database, run this command in SQL Server Management Studio as ‘sa’ (niku is a database name).

USE niku

ALTER USER niku WITH LOGIN=my_user

And,

GRANT VIEW SERVER STATE to my_user

 

Additional Information: 

Installation Guide

Environment:

Release:
Component: PPMENV