SQL Server Security

SQL Server Security, Monitoring and Compliance

Secure your SQL Server estate. Monitor every query. Meet every compliance requirement.

SQL Server is the most widely deployed enterprise database platform, running critical workloads across financial services, healthcare, retail, and the public sector. Its broad adoption makes it a primary target for attackers and a central focus for regulators. DBsafe provides comprehensive security, monitoring, and compliance capabilities specifically designed for SQL Server environments.

73%
of organisations run SQL Server in at least one production workload
CVE-2023
multiple critical SQL Server vulnerabilities discovered in 2023-2024
SA account
default SA account exploitation is the most common SQL Server attack vector
Req. 10
PCI DSS Requirement 10 mandates comprehensive SQL Server audit logging
The Challenge

SQL Server security requires database-layer controls, not just network security

SQL Server environments face threats that network security cannot address. Compromised application credentials enable attackers to query data using the same access paths as legitimate applications. Over-privileged service accounts allow lateral movement from one compromised service to all databases that account can access. Default configuration settings — the SA account, public access to system databases, excessive xp_cmdshell permissions — remain in production deployments years after they should have been hardened.

DBsafe addresses these threats at the database layer, where network controls have no effect.

The cost of inaction

SA account with default or weak password: high-probability exploitation in internet-exposed SQL Server

xp_cmdshell enabled: database compromise leads directly to operating system access

Insufficient SQL Server audit logging: PCI DSS Requirement 10 non-compliance

SQL Server version without security patches: exposure to known CVEs with published exploits

The DBsafe Approach

How DBsafe secures SQL Server environments

01
01

Assess and harden SQL Server configuration

DBsafe runs CIS Benchmark-aligned configuration assessment across all connected SQL Server instances, identifying hardening gaps: SA account status, xp_cmdshell configuration, guest user access, linked server permissions, and authentication mode.

02
02

Discover and classify sensitive data

DBsafe scans all SQL Server databases for PII, cardholder data, and health information, mapping findings to GDPR, PCI DSS, and HIPAA requirements. Column-level classification enables precision access controls.

03
03

Monitor queries and alert on threats

Every T-SQL statement is captured and analysed. Bulk exports, access to sensitive tables by unexpected accounts, off-hours activity, and privilege escalation attempts trigger immediate alerts.

SQL Server configuration hardening

SQL Server's default configuration is not hardened for production security. Common misconfigurations include: the SA account enabled with weak or default credentials, Windows authentication mixed with SQL authentication without policy controls, xp_cmdshell enabled (allowing operating system command execution from SQL), guest user access to system databases, and CLR integration enabled without necessity.

DBsafe's SQL Server configuration assessment checks for all of these issues and provides remediation guidance aligned to the CIS Microsoft SQL Server Benchmark. Assessment runs continuously, detecting configuration drift before it becomes an exploited vulnerability.

SQL Server privilege management

SQL Server privilege escalation is a common attack technique. An attacker who compromises a low-privilege account can exploit SQL Server's permission inheritance model to escalate to db_owner or sysadmin. DBsafe's privilege analysis identifies users with excessive permissions, chains of permission inheritance that enable escalation, and service accounts with permissions beyond what their application role requires.

The principle of least privilege applied consistently across SQL Server instances is the most effective defence against this class of attack. DBsafe enforces it through continuous access reviews and privilege reduction recommendations.

SQL Server Always Encrypted and TDE

SQL Server's Transparent Data Encryption (TDE) encrypts the database file at rest. Always Encrypted provides column-level encryption for particularly sensitive data, ensuring that even users with database access cannot see plaintext values without the column encryption key.

DBsafe verifies TDE status across all SQL Server databases and flags unencrypted databases holding sensitive data as compliance gaps. For Always Encrypted deployments, DBsafe maps the encrypted columns to their relevant compliance framework requirements, providing evidence that appropriate encryption is in place.

SQL Server Audit and Extended Events

SQL Server provides native audit functionality through SQL Server Audit and Extended Events. However, these native tools have limitations: audit configurations can be modified by sysadmin users, audit files are stored on the database server and accessible to server administrators, and the coverage of the native tools is often incomplete.

DBsafe augments or replaces native SQL Server auditing with independent, tamper-evident logging that cannot be modified by SQL Server administrators. Coverage extends to all query types, including those that native SQL Server Audit does not capture.

SQL Server in regulated environments

SQL Server is widely deployed in healthcare, financial services, and public sector environments subject to HIPAA, PCI DSS, GDPR, and FCA requirements. Each framework has specific SQL Server implications: HIPAA requires audit controls and access management for ePHI databases; PCI DSS requires comprehensive logging, access control, and encryption for cardholder data environments; GDPR requires documentation and privacy by design for personal data processing.

DBsafe's compliance framework mapping for SQL Server provides a direct mapping from the SQL Server controls it implements to the specific requirements of each applicable framework, enabling compliance teams to evidence SQL Server controls efficiently.

SQL Server on Azure and Amazon RDS

SQL Server is available as a managed service on both Azure (Azure SQL Database, Azure SQL Managed Instance) and Amazon Web Services (Amazon RDS for SQL Server). Managed SQL Server introduces cloud-specific security considerations: network security group configuration, managed identity vs SQL authentication, Azure Active Directory integration, and cloud-provider shared responsibility model implications.

DBsafe extends its SQL Server security capabilities to both Azure SQL and Amazon RDS for SQL Server, providing consistent monitoring, masking, and compliance reporting regardless of the deployment model.

Platform Capabilities

Everything you need to address SQL Server security — in one integrated platform.

CIS Benchmark Assessment

Configuration hardening checks aligned to CIS Microsoft SQL Server Benchmark.

PII and PAN Discovery

Scan all SQL Server databases for GDPR, PCI DSS, and HIPAA-relevant sensitive data.

T-SQL Query Monitoring

Capture and analyse every T-SQL statement with behavioural anomaly detection.

Privilege Analysis

Identify excessive permissions, privilege escalation chains, and service account over-provisioning.

TDE and Always Encrypted

Verify encryption status and map encrypted columns to compliance requirements.

SQL Server Compliance Reports

GDPR, PCI DSS, and HIPAA-formatted compliance reports for SQL Server environments.

Frequently Asked Questions

Answers to the most common questions about SQL Server security.

What are the most common SQL Server security vulnerabilities?

The most common SQL Server security issues are: SA account enabled with weak credentials, xp_cmdshell enabled allowing OS command execution, overly permissive service account privileges, SQL injection vulnerabilities in application code, insufficient audit logging, and running unpatched versions with known CVEs.

Does DBsafe support SQL Server Always Encrypted?

DBsafe can connect to SQL Server instances using Always Encrypted with column encryption keys, enabling discovery and monitoring of encrypted column metadata. For masking purposes, DBsafe works with plaintext column data using application-side decryption. DBsafe also maps Always Encrypted columns to their relevant compliance framework requirements.

How does DBsafe differ from SQL Server's native audit functionality?

SQL Server's native audit functionality can be modified or disabled by sysadmin users. DBsafe provides independent, tamper-evident logging that cannot be accessed or modified by SQL Server administrators. It also provides richer analysis capabilities including anomaly detection, compliance reporting, and forensic querying that native SQL Server Audit does not offer.

Does DBsafe work with SQL Server on Amazon RDS?

Yes. DBsafe connects to Amazon RDS for SQL Server and SQL Server on Azure SQL Database and Managed Instance using native SQL Server drivers. Cloud-specific security considerations including network security group configuration and managed identity integration are included in the cloud platform assessment modules.

What SQL Server versions does DBsafe support?

DBsafe supports SQL Server 2012 through current versions (2019, 2022), and their cloud equivalents (Azure SQL Database, Azure SQL Managed Instance, Amazon RDS for SQL Server). Support for SQL Server 2008 R2 is available with reduced feature coverage reflecting the limited protocol capabilities of that version.

Ready in 5 minutes

Secure and monitor your SQL Server estate

DBsafe provides the configuration hardening, query monitoring, and compliance reporting that enterprise SQL Server deployments require.