Click on the Policy Template name to order the table according to Security Checks marked as default.

Access Security Checks
CIS for SQL Server 2000
CIS for SQL Server 2005
CIS for SQL Server 2008
CIS for SQL Server 2008 R2
CIS for SQL Server 2012
CIS for SQL Server 2014
CIS for SQL Server 2016
CIS for SQL Server 2017
CIS for SQL Server 2019
DISA-NIST STIG for SQL Server 2012
DISA-NIST STIG for SQL Server 2014
DISA-NIST STIG for SQL Server 2016
European Union General Data Protection Regulation (GDPR)
HIPAA Guidelines for SQL Server
IDERA Level 1 - Basic Protection
IDERA Level 2 - Balanced Protection
IDERA Level 3 - Strong Protection
MS Best Practices Analyzer
NERC Critical Infrastructure Protection
PCI-DSS Guidelines for SQL Server
SNAC for SQL 2000
SOX Section 404
SRR Checklist for SQL Server 2000
SRR Checklist for SQL Server 2005 or later
Analysis Services Running
XXX









X
XX

X



Asymmetric Key Size



XXXXXX














Auto_Close set for contained databases





XXXX





XX






Backups compliance with RTO and RPO requirements









X







X




BUILTIN/Administrators Is sysadmin
XXX


XXX



XXXXX
X

XX
CLR Enabled


XXXXXXX


X


X






Common criteria compliance


X










XXX






Data Files On System Drive













XXXX






Database-level Firewall Rules














XXX






Databases Are Trustworthy



XXXXXXXXXXX

X

X


X
Default Trace Enabled


XXXXXXX














Full-Text Search Running

XX









X
XX






HADR is configured












X


X






Hide Instance Option is set



XXXXXX




XXX






Integration Services
X






















Linked servers are configured
























Max Number of concurrent sessions









X



XXX






Maximum number of error log files


XXXXXXX





XX






Ole automation procedures


XXXXXXX


X

XX






Other General Domain Accounts
















X






Replication Enabled

XX









X
XX

X

XX
sa Account Not Disabled



XXXXXXXXX
XXXX
XX



sa Account Not Disabled Or Renamed

XXXXXXXXXXX
XXXX
XX


X
Sample Databases Exist
XXX





XXXX

XX


X
XX
Server Is Domain Controller

XX









XXXXX





Server-level Firewall Rules














XXX






Shutdown SQL Server on Trace Failure










XX



X






SQL Agent Mail
XXX









X
XX


X

X
SQL Mail Or Database Mail Enabled
XXXXXXXXX



X
XX


X
XX
SQL Server Installation Directories On System Drive













XXXX






SQL Server Version
XXXXXXXXX



XXXXXXXX
XX
System Table Updates
XXX









XXXX

X

X
Transport Layer Security












X


X






Unauthorized Account Check













X

X
XX


X
User created 'sa' account does not exist





XXXX





XX






VSS Writer Running













X

X

X



xp_cmdshell Enabled

XXXXXXXXXXXXXXXX

X


X
xp_cmdshell Proxy Account Exists

XX









XXXXX
X



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal