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

Summary

In this chapter, you learned about authentication and encryption in SQL Server 2008. Hopefully, one thing you took away from this discussion was the importance of strong authentication and information about how to provide this through SQL Server features and functions. You also learned how to create and manage principals and roles. Integral to this discussion was information on creating logins—both SQL logins and mapped Windows logins. You also learned about the server and database roles and how they provide simpler security management for SQL Servers. Finally, you explored the encryption options available in SQL Server 2008. These options include application-level encryption and transparent data encryption. In the next chapter, you'll ...