Chapter 7. SQL Server 2005 Security

IN THIS CHAPTER

• An Introduction to Security in SQL Server 2005

• Authentication

• Authorization

• Auditing Enhancements

• Cryptography Support

• Surface Area Configuration (SAC)

• SQL Server Agent Security Overview

• SQLCLR Security Overview

• Service Broker Security Overview

On January 24, 2003, a worm named Sapphire or W32.Slammer attacked the computers running SQL Server 2000 and MSDE 2000, propagating via UDP Port 1434 and causing a dramatic increase in network traffic. This incident reinforced the importance of the ongoing Trustworthy Computing initiative. In the past two years, Microsoft has invested significant time and resources in enhancing the security in each of its products, including SQL Server ...

Get Microsoft® SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta 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.

Start your free trial