The Azure SQL Managed Instance must be configured to prohibit or restrict the use of organization-defined functions, ports, protocols, and/or services, as defined in the Ports, Protocols, and Services Management Category Assurance List (PPSM CAL) and vulnerability assessments.

Severity	Group ID	Group Title	Version	Rule ID	Date	STIG Version
medium	V-276246	SRG-APP-000142-DB-000094	MSQL-00-007700	SV-276246r1150054_rule	2025-10-07	1

Description
To prevent unauthorized connection of devices, unauthorized transfer of information, or unauthorized tunneling (i.e., embedding of data types within data types), organizations must disable or restrict unused or unnecessary physical and logical ports/protocols/services on information systems. Applications are capable of providing a wide variety of functions and services. Some of the functions and services provided by default may not be necessary to support essential organizational operations. Additionally, it is sometimes convenient to provide multiple services from a single component (e.g., email and web services); however, doing so increases risk over limiting the services provided by any one component. To support the requirements and principles of least functionality, the application must support the organizational requirements providing only essential capabilities and limiting the use of ports, protocols, and/or services to only those required, authorized, and approved to conduct official business or to address authorized quality of life issues. Database management systems using ports, protocols, and services deemed unsafe are open to attack through those ports, protocols, and services. This can allow unauthorized access to the database and through the database to other components of the information system. Satisfies: SRG-APP-000142-DB-000094, SRG-APP-000383-DB-000364

Description

To prevent unauthorized connection of devices, unauthorized transfer of information, or unauthorized tunneling (i.e., embedding of data types within data types), organizations must disable or restrict unused or unnecessary physical and logical ports/protocols/services on information systems. Applications are capable of providing a wide variety of functions and services. Some of the functions and services provided by default may not be necessary to support essential organizational operations. Additionally, it is sometimes convenient to provide multiple services from a single component (e.g., email and web services); however, doing so increases risk over limiting the services provided by any one component. To support the requirements and principles of least functionality, the application must support the organizational requirements providing only essential capabilities and limiting the use of ports, protocols, and/or services to only those required, authorized, and approved to conduct official business or to address authorized quality of life issues. Database management systems using ports, protocols, and services deemed unsafe are open to attack through those ports, protocols, and services. This can allow unauthorized access to the database and through the database to other components of the information system. Satisfies: SRG-APP-000142-DB-000094, SRG-APP-000383-DB-000364

ℹ️ Check
Azure SQL Managed Instance must only use approved firewall settings, including disabling public network access. This value is not allowed by default in Azure SQL Managed Instance and must be disabled if not otherwise documented and approved. Obtain a list of all approved firewall settings from the database documentation: 1. From the Azure Portal, click the storage account. 2. Click "Networking" under Security. 3. Verify the public network endpoint option is set to disabled. If the value is enabled and not specifically approved in the database documentation, this is a finding. Verify Network Security Groups (NSG) are configured to restrict access only to the resources that require access to the managed instance. If access is not restricted, this is a finding.

ℹ️ Check

Azure SQL Managed Instance must only use approved firewall settings, including disabling public network access. This value is not allowed by default in Azure SQL Managed Instance and must be disabled if not otherwise documented and approved. Obtain a list of all approved firewall settings from the database documentation: 1. From the Azure Portal, click the storage account. 2. Click "Networking" under Security. 3. Verify the public network endpoint option is set to disabled. If the value is enabled and not specifically approved in the database documentation, this is a finding. Verify Network Security Groups (NSG) are configured to restrict access only to the resources that require access to the managed instance. If access is not restricted, this is a finding.

✔️ Fix
Assign the approved policy to Azure SQL Managed Instance: 1. From the Azure Portal, click the Azure SQL Managed Instance. 2. Click "Networking" under Security. 3. Review the public endpoint option. 4. Check the box to "Disable" public endpoint. 5. Click "Save". Review the Azure SQL Managed Instance's NSG configuration for inbound and outbound rules to restrict access to specific ports and resources. For more information about connection policies, refer to: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connectivity-architecture-overview?view=azuresql&tabs=current

✔️ Fix

Assign the approved policy to Azure SQL Managed Instance: 1. From the Azure Portal, click the Azure SQL Managed Instance. 2. Click "Networking" under Security. 3. Review the public endpoint option. 4. Check the box to "Disable" public endpoint. 5. Click "Save". Review the Azure SQL Managed Instance's NSG configuration for inbound and outbound rules to restrict access to specific ports and resources. For more information about connection policies, refer to: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connectivity-architecture-overview?view=azuresql&tabs=current