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: