MSSQL database restore throws error Invalid object name 'cmn_option_values' (on different tables). and uses dbo for schema

book

Article ID: 143306

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

After MSSQL database restore, the schema used still seems to be dbo, how to fix this? 

Environment

Release : All Supported Clarity with MSSQL 

Resolution

Run the commands as follows (do not change the database name):

sp_change_users_login 'AUTO_FIX', 'niku'

sp_change_users_login 'AUTO_FIX', 'ppm_dwh'

 

OR

 

Make sure in SQL Management Console that default schema name for the niku user id is niku and ppm_dwh user id is ppm_dwh