How to fix permission in SQL Server - CA PPM

Document ID : KB000033325
Last Modified Date : 14/02/2018
Show Technical Document Details

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