ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
SQL Server requires the VIEW SERVER STATE permission
Article ID: 52204
Clarity PPM SaaSClarity PPM On Premise
Clarity requires the VIEW SERVER STATE permission with MS SQL. Why is this required?
Release: All Supported Releases
This is "as designed" and required for proper Clarity functionality, as there are areas of the product that require its use. The following are some of the areas that require its use.
cmn_dblocks_sp, which is used for monitoring deadlocking scenarios (this is a diagnostic stored procedure).
Financial GL transaction posting to prevent data corruption due to multiple concurrent executions.
Financial Post to WIP function to prevent data corruption due to multiple concurrent executions.
Clarity configuration code reads this to determine if this permission is set and will log this to the logs if it is not set. This configuration is accessible and available for developers to use for future features.