SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Chapter Essentials

Security Defined Security is a complex topic that was briefly introduced in this chapter. If security is defined as an acceptable level of risk, rather than no risk, it may be achieved. Security involves the systems, people, and processes working together to achieve this acceptable level of risk.

Security Threats Security threats are many. SQL Servers may be attacked from four major attack points. The first is the Windows Server operating system on which the SQL Server runs. The second is the SQL Server service itself. The third is the network infrastructure that allows for communications with the SQL Server. The final and fourth attack point is the client. The client may be a desktop or laptop computer or it may be another ...