SV-213976r1137657_rule
V-213976
SRG-APP-000243-DB-000373
SQL6-D0-009900
CAT II
10
If IFI is not documented as being required, disable instant file initialization for the instance of SQL Server by removing the SQL Service SID and/or service account from the "Perform volume maintenance tasks" Local Rights Assignment.
Review system configuration to determine whether IFI support has been enabled (by default in SQL Server 2016).
Start >> Control Panel >> System and Security >> Administrative Tools >> Local Security Policy >> Local Policies >> User Rights Assignment >> Perform volume maintenance tasks
The default SQL service account for a default instance is NT SERVICE\MSSQLSERVER or for a named instance is NT SERVICE\MSSQL$InstanceName.
If the SQL service account or SQL service SID has been granted "Perform volume maintenance tasks" Local Rights Assignment, this means that Instant File Initialization (IFI) is enabled.
Review the system documentation to determine if Instant File Initialization (IFI) is required.
If IFI is enabled but not documented as required, this is a finding.
If IFI is not enabled, this is not a finding.
V-213976
False
SQL6-D0-009900
Review system configuration to determine whether IFI support has been enabled (by default in SQL Server 2016).
Start >> Control Panel >> System and Security >> Administrative Tools >> Local Security Policy >> Local Policies >> User Rights Assignment >> Perform volume maintenance tasks
The default SQL service account for a default instance is NT SERVICE\MSSQLSERVER or for a named instance is NT SERVICE\MSSQL$InstanceName.
If the SQL service account or SQL service SID has been granted "Perform volume maintenance tasks" Local Rights Assignment, this means that Instant File Initialization (IFI) is enabled.
Review the system documentation to determine if Instant File Initialization (IFI) is required.
If IFI is enabled but not documented as required, this is a finding.
If IFI is not enabled, this is not a finding.
M
3993