Skip to main content
Security Center for SQL Server Database Engine and Azure SQL Database

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Authentication: Who are you?

Authorization: What can you do?

Encryption: Storing Secret Data

Connection Security: Restricting and Securing

Auditing: Recording Access

Who Authenticates?                         

Security_Center_Map_Windows_Authentication
Security_Center_Map_SQL_Authentication

 

Where Authenticated?

Security_Center_Map_Logins_Users
Security_Center_Map_Contained_Users

 

Using Other Identities

Security_Center_Map_Credentials
Security_Center_Map_Exec_As_Login
Security_Center_Map_Exec_As_User
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder

Granting, Revoking, and Denying Permissions

Security_Center_Map_Securable_Classes
Security_Center_Map_Srv_Perms
Security_Center_Map_DB_Perms

 

Security by Roles

Security_Center_Map_Srv_Roles
Security_Center_Map_DB_Roles

 

Restricting Data Access to Selected Data Elements

Security_Center_Map_View_Procs
Security_Center_Map_Row_Level_Sec
Security_Center_Map_Data_Masking
Security_Center_Map_Signed_Objects
Security_Center_Map_BlankPlaceholder

Encrypting Files                           

Security_Center_Map_BitLocker
Security_Center_Map_NTFS_Encryp
Security_Center_Map_TDE
Security_Center_Map_Backup_Encryp

 

Encrypting Sources

Security_Center_Map_EKM
Security_Center_Map_Key_Vault
Security Center Map Always Encrypted

 

Column, Data & Key Encryption

Security_Center_Map_Cert
Security_Center_Map_Sym_Key
Security_Center_Map_Asym_Key
Security_Center_Map_Passphrase

Firewall Protection                        

Security_Center_Map_Windows_Firewall
Security_Center_Map_Service_Firewall
Security_Center_Map_DB_Firewall

 

Encrypting Data in Transit

Security_Center_Map_Forced_SSL
Security_Center_Map_Opt_SSL
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder

Automated Auditing                         

Security_Center_Map_SQL_Audit
Security_Center_Map_SQLDB_Audit

 

Custom Audit

Security_Center_Map_Triggers
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_Legend
Links to Specific Related Topics
Small File Folder IconAuthentication: 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 IconEncryption: Storing Secret Data

Encrypting Files

Encrypting Sources

Column, Data and Key Encryption

Small File Folder IconAuthorization: What can you do?

Granting, Revoking, and Denying Permissions

Security by Roles

Restricting Data Access to Selected Data Elements

Small File Folder IconConnection Security: Restricting and Securing

Firewall Protection

Encrypting Data in Transit

Small File Folder IconAuditing: Recording Access

Automated Auditing

Custom Audit Implementation

Creating DDL Triggers and DML Triggers

Microsoft is conducting an online survey to understand your opinion of the MSDN Web site. If you choose to participate, the online survey will be presented to you when you leave the MSDN Web site.

Would you like to participate?