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

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?                         

 

Where Authenticated?

 

Using Other Identities

Placeholder
Placeholder
Placeholder
Placeholder

Granting, Revoking, and Denying Permissions

 

Security by Roles

 

Restricting Data Access to Selected Data Elements

Placeholder

Encrypting Files                           

 

Encrypting Sources

 

Column, Data & Key Encryption

Firewall Protection                        

 

Encrypting Data in Transit

Placeholder
Placeholder
Placeholder
Placeholder
Placeholder
Placeholder
Placeholder

Automated Auditing                         

 

Custom Audit

Placeholder
Placeholder
Placeholder
Placeholder
Placeholder
Security Center Legend
Links to Specific Related Topics
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

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?