MSSQL upgrade fails on VIEW SERVER STATE permission

Article Id: 196421
Status: Published
Updated On: 02-08-2020 18:30
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