Skip to content

create-a-database-master-key.md

Latest commit

 

History

History
42 lines (32 loc) · 1.62 KB

create-a-database-master-key.md

File metadata and controls

42 lines (32 loc) · 1.62 KB
title Create a Database Master Key
description Create a database master key in SQL Server by using Transact-SQL. Be sure you have the required permissions.
author jaszymas
ms.author jaszymas
ms.reviewer vanto
ms.date 09/12/2019
ms.service sql
ms.subservice security
ms.topic how-to
helpviewer_keywords
database master key [SQL Server], creating
monikerRange >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

Create a Database Master Key

[!INCLUDE SQL Server] This topic describes how to create a database master key in [!INCLUDEssnoversion] by using [!INCLUDEtsql].

Security

Permissions

Requires CONTROL permission on the database.

Using Transact-SQL

To create a database master key

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

  2. In Object Explorer, connect to an instance of [!INCLUDEssDE].

  3. Expand System Databases, right-click master and then click New Query.

  4. Copy and paste the following example into the query window and click Execute.

      -- Creates the master key.
  -- The key is encrypted using the password "23987hxJ#KL95234nl0zBe".  
  CREATE MASTER KEY ENCRYPTION BY PASSWORD = '23987hxJ#KL95234nl0zBe';

For more information, see CREATE MASTER KEY (Transact-SQL).