VA2114 - Minimal set of principals should be members of fixed server roles

Praveenraj R K 61 Reputation points Microsoft Employee
2023-03-02T12:33:01.91+00:00

Hi Team,

I got below Vulnerabilities for the Azure SQL Managed Instance. Could you please provide the remediation for the VA ?

VA2114 - Minimal set of principals should be members of fixed server roles

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 32,806 Reputation points MVP
    2023-03-02T13:37:38.5566667+00:00

    Remove members that should not have access to the fixed server roles. After that approve as baseline.User's image

    Here are the fixed roles except ##MS_PerformanceDefinitionReader##, ##MS_ServerPerformanceStateReader##, and ##MS_ServerSecurityStateReader#