Chapter 3
SQL Password Security
Information in this chapter:
• SQL Server Password Security
• Strong Passwords
• Contained Database Logins in SQL Server 2012
• Encrypting Client Connection Strings
• Application Roles
• Using Windows Domain Policies to Enforce Password Length
• Contained Databases
• Summary
SQL Server Password Security
One of the key ways to protect your SQL Server is to use strong, secure passwords for your SQL Server login accounts. One of the biggest security holes in the SQL Server 2000 and older versions of Microsoft SQL Server was that the server was installed with a blank system administrator (SA) password by default and would allow you to use a blank password, thereby permitting anyone to connect without much work at ...
Get Securing SQL Server, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
