How to fix permission in SQL Server - CA PPM

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM SaaS - Application
• 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: 

Installation Guide

Environment

Release:
Component: PPMENV