How to associate the restore database to my MS SQL Server user? I can’t create a new object in CA Clarity
After restored CA Clarity Database, run this command in SQL Server Management Studio as ‘sa’ (niku is a database name).
ALTER USER niku WITH LOGIN=my_user
GRANT VIEW SERVER STATE to my_user