Create a Database Master Key
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
This topic describes how to create a database master key in SQL Server by using Transact-SQL.
Security
Permissions
Requires CONTROL permission on the database.
Using Transact-SQL
To create a database master key
Choose a password for encrypting the copy of the master key that will be stored in the database.
In Object Explorer, connect to an instance of Database Engine.
Expand System Databases, right-click
master
and then click New Query.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).
Tilbakemeldinger
https://aka.ms/ContentUserFeedback.
Kommer snart: Gjennom 2024 faser vi ut GitHub Issues som tilbakemeldingsmekanisme for innhold, og erstatter det med et nytt system for tilbakemeldinger. Hvis du vil ha mer informasjon, kan du se:Send inn og vis tilbakemelding for