MSSQL upgrade fails on VIEW SERVER STATE permission

Products

• Clarity PPM On Premise

Issue/Introduction

MSSQL upgrade fails, error in logs: 

 

<Exception><![CDATA[SQL Exception with error code : 300 message: [CA Clarity][SQLServer JDBC Driver][SQLServer]VIEW SERVER STATE permission was denied on object 'server', database 'master'.]]></Exception>

Environment

Release : All supported Clarity releases

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

VIEW SERVER STATE permission is required for the MSSQL databases with Clarity. Please rollback, grant the permission and start the upgrade again