Securing SQL Server

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

•Linked Servers

•Using Policies to Secure Your Instance

•SQL Azure Specific Settings

•Instances That Leave the Office

This chapter talks about how to secure the instance itself from what to install on the instance, and how to secure various parts of the SQL Server instance.

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 ...