Skip to content

create-a-database-master-key.md

Latest commit

 

History

History
66 lines (49 loc) · 2.25 KB

create-a-database-master-key.md

File metadata and controls

66 lines (49 loc) · 2.25 KB

title: "Create a Database Master Key | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.service: "" ms.component: "security" ms.reviewer: "" ms.suite: "sql" ms.technology:

  • "database-engine" ms.tgt_pltfrm: "" ms.topic: conceptual helpviewer_keywords:
  • "database master key [SQL Server], creating" ms.assetid: 8cb24263-e97d-4e4d-9429-6cf494a4d5eb caps.latest.revision: 16 author: "edmacauley" ms.author: "edmaca" manager: "craigg" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"

Create a Database Master Key

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] This topic describes how to create a database master key in [!INCLUDEssCurrent] by using [!INCLUDEtsql].

In This Topic

Before You Begin

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. On the Standard bar, click New Query.

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

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

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