What is the service master key?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the service master key?
Rating:
The service master key is automatically generated when a credential is encrypted first time. The service master key is derived from SQL Server service accounts having the Windows credentials. It is encrypted by Windows Data Protection API. It can be decrypted only by the service account under which it is created or by a principal that can access the service account.
Rating:
Was this information helpful?
Other articles
- MCITP 70-443 Exam Passing Tips
- What is the RESTORE REWINDONLY statement?
- What is the LEFT OUTER JOIN?
- What are the types of capacity planning?
- Tip for server roles.