How to fix permission in SQL Server - CA PPM

book

Article ID: 33325

calendar_today

Updated On:

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