Security Center for SQL Server Database Engine and Azure SQL Database

Security Center for SQL Server Database Engine and Azure SQL Database

 

Updated: September 23, 2015

This page provides links to help you locate the information that you need about security and protection in the SQL Server Database Engineand Azure SQL Database.

System_CAPS_ICON_note.jpg Note


The capabilities of Azure SQL Database continue to improve. See the most recent version of this topic for the most recent information about SQL Database.

Authentication: Who are you?Authorization: What can you do?Encryption: Storing Secret DataConnection Security: Restricting and SecuringAuditing: Recording Access
Who Authenticates?

 Security Center Map Windows Authentication

 

 Security Center Map SQL Server Authentication

 Where Authenticated?

 Security Center Map Logins and Users

 

 Security Center Map Contained Database Users

 Using Other Identities

 Security Center Map Credentials

 Security Center Map Execute As Login

 Security Center Map Execute As User

 Placeholder

 Placeholder

 Placeholder

 Placeholder
Granting, Revoking, and Denying Permissions

 Security Center Map Securable Classes

 Security Center Map Server Permissions

 Security Center Map Database Permissions

 Security by Roles

 Security Center Map Server Roles

 Security Center Map Database Roles

 Restricting Data Access to Selected Data Elements

 Security Center Map Views and Procedures

 Security Center Map Row Level Security

 Security Center Map Dynamic Data Masking

 Security Center Map Signed Objects

 Placeholder
Encrypting Files

 Security Center Map BitLocker

 Security Center Map NTFS Encryption

 Security Center Map TDE

 Security Center Map Backup Encryption

 Encrypting Sources

 Security Center Map EKM

 Security Center Map Azure Key Vault

 Column, Data & Key Encryption

 Security Center Map Encrypt by Certificate

 Security Center Map Encrypt by Symmetric Key

 Security Center Map Encrypt by Asymmetric Key

 Security Center Map Encrypt by Passphrase
Firewall Protection

 Security Center Map Windows Firewall

 Security Center Map Service Firewall

 Security Center Map Database Firewall

 Encrypting Data in Transit

 Security Center Map Forced SSL

 Security Center Map Optional SSL

 Placeholder

 Placeholder

 Placeholder

 Placeholder

 Placeholder

 Placeholder

 Placeholder
Automated Auditing

 Security Center Map SQL Server Audit

 Security Center Map SQL Database Audit

 Custom Audit

 Placeholder

 Security Center Map Triggers

 Compliance

 SecCtrCompliance

 Placeholder

 Placeholder

 Placeholder

 Placeholder

 Placeholder

 Security Center Legend

Small File Folder Icon Authentication: Who are you?
Who Authenticates? (Windows or SQL Server)

Authenticate at the master database (Logins and database users)

Authenticate at a user database

Using Other Identities

Small File Folder Icon Encryption: Storing Secret Data
Encrypting Files

Encrypting Sources

Column, Data and Key Encryption

Small File Folder Icon Authorization: What can you do?
Granting, Revoking, and Denying Permissions

Security by Roles

Restricting Data Access to Selected Data Elements

Small File Folder Icon Connection Security: Restricting and Securing
Firewall Protection

Encrypting Data in Transit

Small File Folder Icon Auditing: Recording Access
Automated Auditing

Custom Audit Implementation

Small File Folder Icon Compliance
SQL Server

SQL Database

Securing SQL Server
Principals (Database Engine)
SQL Server Certificates and Asymmetric Keys
SQL Server Encryption
Surface Area Configuration
Strong Passwords
TRUSTWORTHY Database Property
Database Engine Features and Tasks

Show:
© 2016 Microsoft