MSSQL upgrade fails on VIEW SERVER STATE permission
Article ID: 196421
Updated On:
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
Feedback
Yes
No
Powered by
