In this article

How to: Create a Database Master Key

12/03/2008

2 minutes to read

In this article

New: 17 July 2006

The database-level cryptographic features in SQL Server rely on a database master key. This key is not generated automatically when the database is created; it must be created by the system administrator. It is only necessary to create the master key once per database.

To create a database master key

In Query Editor, connect to the database by executing the following Transact-SQL command: USE <database name> ; GO.

Choose a password for encrypting the copy of the master key that will be stored in the database.