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