Chapter 4

Securing the Instance

Information in this chapter:

• What to Install, and When

• SQL Authentication and Windows Authentication

• Password Change Policies

• Auditing Failed Logins

• Renaming the SA Account

• Disabling the SA Account

• Securing Endpoints

• Stored Procedures as a Security Measure

• Minimum Permissions Possible

• Instant File Initialization

• Linked Servers

• Using Policies to Secure Your Instance

• SQL Azure Specific Settings

• Instances That Leave the Office

• Securing “Always On”

• Securing Contained Databases

• Summary

What to Install, and When?

When building a new Microsoft SQL Server, proper security planning starts even before you launch the SQL Server installer. Each component of the Microsoft SQL Server product ...

Get Securing SQL Server, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.