SV-276318r1150020_rule
V-276318
SRG-APP-000141-DB-000092
MSQL-D0-016300
CAT II
10
Modify the Azure SQL Managed Instance's [sa] account name by running the following example script:
USE master;
GO
ALTER LOGIN [sa] WITH NAME = NewAccountName
Verify the Azure SQL Managed Instance default [sa] account name has been changed by executing the following query:
USE master;
GO
SELECT name FROM sys.sql_logins WHERE UPPER(name) = 'SA' OR principal_id = 1;
If the name returned has the consecutive letters "sa" in the query output, this is a finding.
V-276318
False
MSQL-D0-016300
Verify the Azure SQL Managed Instance default [sa] account name has been changed by executing the following query:
USE master;
GO
SELECT name FROM sys.sql_logins WHERE UPPER(name) = 'SA' OR principal_id = 1;
If the name returned has the consecutive letters "sa" in the query output, this is a finding.
M
5711