Standard ports


Job details

Name: Standard ports
Platform: Sqlserver
Category: Security
Premium package: Security and compliance package
Description: Verify the usage of standard ports, with TCP port 1433 being the default.
Long description: Verify the usage of standard ports, with TCP port 1433 being the default. Conducting a comprehensive examination of the active port configurations is a crucial step in ensuring a robust and secure network infrastructure.
Version: 1.23
Default schedule: 29 1 1 *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2005′ & hasengine=‘YES’ & eng_inst_priv = 0 & (engine_edition = ‘Microsoft SQL Server’ engine_edition = ‘Azure SQL Managed Instance’)]

Parameters

Name Default value Description
return status 1 Return status value (ALARM – 2, WARNING – 1, or OK – 0) when ports listed in parameter “not permitted ports” are in use.
not permitted ports 1433 List of not permitted ports.
history threshold 365 The maximum number of days to keep statistics for in the historic tables.

Job Summary

SELECT local_tcp_port, count(*) FROM sys.dm_exec_connections GROUP BY local_tcp_port ORDER BY 2 DESC

Job Details

Implementation

The tasks performed by the job implementation are as follows:

Dependencies

This job depends on the following database objects for its operation:

Reporting

Scheduling

Upgrade Path

Compliance and Security

In conclusion, this monitoring job is crucial for maintaining the security and compliance of the SQL Server environment by tracking and managing port usage effectively.