I am looking for a complete list of items that the Service Master Key is used to protect in SQL Server 2008.
Sql-server – What does the Service Master Key protect
encryptionSecuritysql-server-2008
Related Question
- Sql-server – Stored procedure encryption and master service master key, SQL Server 2008
- SQL Server Encryption – Is Data Encrypted by ENCRYPTBYPASSPHRASE() Protected by Service Master Key?
- Why does the service broker require a master key after restoring to a different server
- Sql-server – Restore Database w Master Key and storing password in plain text
- SQL Server – Restore Database with Encrypted Column Without Overwriting Service Master Key
- SQL Server – Are Database Master Keys Protected with the Same Password Identical?
- SQL Server – When is Service Master Key Generated?
Best Answer
Look at the encryption hierarchy found in this TechNet article. This document from MS shows the entire hierarchy. You can see that the Master Key is created from the Windows DPAPI service and is used for:
-DB Master Key
-Certificates
-Symmetric Keys
-Asymmetric Keys
-TDE
-Transact SQL Encryption Functions
-Passwords (I'm not 100% on this, but it is in the technet article and it was mentioned in the comments so I added it)
Was this for a school project or a cert exam? Do you need any more background info?