SV-276317r1150033_rule
V-276317
SRG-APP-000033-DB-000084
MSQL-D0-016200
CAT II
10
Modify the enabled flag of Azure SQL Managed Instance's [sa] account by running the following script:
USE master;
GO
ALTER LOGIN [sa] DISABLE;
GO
Check Azure SQL Managed Instance settings to determine if the [sa] account has been disabled by executing the following query:
USE master;
GO
SELECT name, is_disabled
FROM sys.sql_logins
WHERE principal_id = 1;
GO
The "name" column contains the current name of the [sa] database server account.
If the "is_disabled" column is not set to "1", this is a finding.
V-276317
False
MSQL-D0-016200
Check Azure SQL Managed Instance settings to determine if the [sa] account has been disabled by executing the following query:
USE master;
GO
SELECT name, is_disabled
FROM sys.sql_logins
WHERE principal_id = 1;
GO
The "name" column contains the current name of the [sa] database server account.
If the "is_disabled" column is not set to "1", this is a finding.
M
5711