Remote admin connections

Name:	Remote admin connections
Platform:	Sqlserver
Category:	Security
Premium package:	Security and compliance package
Description:	Checks whether a client application on a remote computer can use the Dedicated Administrator Connection (DAC).
Long description:	Checks whether a client application on a remote computer can use the Dedicated Administrator Connection (DAC).
Version:	1.2
Default schedule:	24 1 1 *
Requires engine install:	Yes
Compatibility tag:	[CDATA[.[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 the “remote admin connections” parameter is enabled.
return status if failover cluster	0	Return status value (ALARM – 2, WARNING – 1, or OK – 0) when Server instance is configured in a failover cluster regardless of enabled “remote admin connections” parameter value.
disable remote admin connections	NO	If set to “YES” the alert will disable “remote admin connections” (if it is enabled) by running sp_configure stored procedure.
history threshold	365	The maximum number of days to keep statistics for in the historic tables.

Feedback