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 5

SQL Password Security

Abstract

This chapter talks about the best practices for creating strong passwords, and ways to deploy your application and protect the potentially sensitive information within the connection string.

Keywords

encryption
hashing
HBA
MPIO
transparent data encryption
IP security

Information in this chapter

Login types
SQL server password security
Strong passwords
Password change policies
Renaming the “SA” account
Disabeling the “SA” account
Users versus logins
Contained database users in SQL server 2012 and beyond
Schemas
Encrypting client connection strings
Application roles
Using windows domain policies to enforce password length
Contained users

Login Types

Any person or application ...
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