ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
How to fix permission in SQL Server - CA PPM
Article ID: 33325
Updated On:
Products
Clarity PPM SaaS
Clarity PPM On Premise
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:
Environment
Release:
Component: PPMENV
Component: PPMENV
Feedback
Yes
No
Powered by
