Page History

You can use the IDERA and industry-standard policy templates built in to into IDERA SQL Secure to further harden your SQL Server SQL Server security model. By creating policies from these templates, you can enforce consistent security settings across your enterprise and proactively assess when and where vulnerabilities exist. You can also customize new policies based on these templates to further address your specific security needs.

...

Available templates

CIS for SQL Server SQL Server 2000

Enforces security check settings derived from the Center for Internet Security - Security Configuration Benchmark for Microsoft SQL Server SQL Server 2000.

CIS for SQL Server CIS for SQL Server 2005

Enforces security check settings derived from the Center for Internet Security - Security Configuration Benchmark for Microsoft SQL Server SQL Server 2005.

CIS for SQL Server CIS for SQL Server 2008

Enforces security check settings derived from the Center for Internet Security - Security Configuration Benchmark for Microsoft SQL Server SQL Server 2008.

CIS for SQL Server CIS for SQL Server 2008 R2

Enforces security check settings derived from the Center for Internet Security - Security Configuration Benchmark for Microsoft SQL Server SQL Server 2008 R2.

CIS for SQL Server CIS for SQL Server 2012

Enforces security check settings derived from the Center for Internet Security - Security Configuration Benchmark for Microsoft SQL Server 2012SQL Server 2012.

CIS for SQL Server CIS for SQL Server 2014

Enforces security check settings derived from the Center for Internet Security - Security Configuration Benchmark for Microsoft SQL Server SQL Server 2014.

CIS for SQL Server CIS for SQL Server 2016

Enforces security check settings derived from the Center for Internet Security - Security Configuration Benchmark for Microsoft SQL Server SQL Server 2016.

CIS for SQL Server CIS for SQL Server 2017

Enforces security check settings derived from the Center for Internet Security - Security Configuration Benchmark for Microsoft SQL Server SQL Server 2017.

CIS for SQL Server CIS for SQL Server 2019

Enforces security check settings derived from the Center for Internet Security - Security Configuration Benchmark for Microsoft SQL Server SQL Server 2019.

DISA-NIST STIG for SQL Server 2012

Enforces security check settings derived from the Defense Information Systems Agency (DISA) National Institute of Standars Standards and technology Technology (NIST) - SQL Server 2012 STIG.

...

Enforces security check settings derived from the Defense Information Systems Agency (DISA) National Institute of Standars Standards and technology Technology (NIST) - SQL Server 2014 Instance STIG.

DISA-NIST STIG for SQL Server 2016

Enforces security check settings derived from the Defense Information Systems Agency (DISA) National Institute of Standards and Technology (NIST) - SQL Server 2016 Instance STIG.

European Union General Data Protection Regulation (GDPR)

The General Data Protection Regulation (GDPR), agreed upon by the European Parliament and Council in April 2016, will replace the Data Protection Directive 95/46/ec in Spring 2018 as the primary law regulating how companies protect EU citizens' personal data.

HIPAA Guidelines for SQL ServerSQL Server

Leverages the Health Insurance Portability and Accountability Act (HIPAA) guideline as well as the Department of Defense Database Security Technical Implementation Guide (STIG). These guidelines target conditions that undermine the integrity of security, contribute to inefficient security operations and administration , or may lead to interruption of production operations for health information that resides on Microsoft SQL Server.

...

Enables the maximum security checks for mission-critical SQL Server and Azure SQL databases that support Web-based, B2B, B2C, or external clients to prevent unauthorized disclosure and data tampering. This template combines IDERA Level 2 and the DISA guidelines with SRR regulations. Also included are additional security checks for auditing, permissions, surface area configurations, and other vulnerabilities.

MS Best MS Best Practices Analyzer

Enforces security check settings derived from the Microsoft SQL Server SQL Server 2005 Best Practices Analyzer Security Recommendations.

...

Enforces security check settings derived from the Payment Card Industry (PCI) v3.0 guideline. This guideline leverages the SQL Server Database Security Readiness Review (SRR) and targets conditions that undermine the integrity of security, contribute to ineficient inefficient security operations and administration, or may lead to interruption of production operations.

SNAC for SQL 2000SQL 2000

Enforces security check settings derived from the Guide to the Secure Configuration and Administration of Microsoft SQL Server SQL Server 2000, Network Applications Team of the Systems and Network Attack Center (SNAC).

...

Enforces security check settings derived from the Sarbanes-Oxley (SOX) Section 404

SRR Checklist SRR Checklist for SQL Server SQL Server 2000

Enforces security check settings derived from the DISA for a security readiness review (SRR)  of of a Microsoft SQL Server SQL Server RDBMS installed in a Windows NT or NT or Windows 2000 host operation system environment.

SRR Checklist SRR Checklist for SQL Server SQL Server 2005 or later

Enforces security check settings derived from the Database Security Readiness Review (SRR) of a Microsoft SQL Server RDBMS. This SRR targets conditions the undermine the integrity of security, contribute to inefficient security operations and administration, and may lead to interruption of production operations. This version can also be applied to SQL Server SQL Server 2008 and later.

Select a template

Use the industry-standard policy templates, such as the CIS for SQL Server for SQL Server 2005 template, when your environment needs to meet the exact security criteria defined by that regulatory organization. However, your environment may contain SQL Server SQL Server instances that only need to follow your corporate security policies. In those cases, you can create new or enhance existing corporate policies based on the built-in IDERA security level templates.

The IDERA Level 1, Level 2, and Level 3 templates allow you to mature your SQL Server SQL Server security model over time, graduating from a solid baseline to an intermediate level to a more advanced and hardened approach. Each level is based on regulatory models and industry best - practices as well as additional security checks that identify vulnerabilities other standards do not address. The default All Servers policy enforces the IDERA Level 2 - Balanced template.

Use the following table to determine which IDERA security level template fits your current security needs and how your environment fits into the overall security maturation model.