Skip to Main Content
Securing SQL Server, 3rd Edition
book

Securing SQL Server, 3rd Edition

by Denny Cherry
April 2015
Intermediate to advanced content levelIntermediate to advanced
462 pages
13h 59m
English
Syngress
Content preview from Securing SQL Server, 3rd Edition
Chapter 6

Securing the Instance

Abstract

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.

Keywords

password policies
SA account
endpoints
stored procedures
permissions
policies

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
SQL CLR
Extended stored procedures ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Securing SQL Server: DBAs Defending the Database

Securing SQL Server: DBAs Defending the Database

Peter A. Carter
SQL Server 2019 Administration Inside Out

SQL Server 2019 Administration Inside Out

Randolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D’Antoni

Publisher Resources

ISBN: 9780128012758