Creating a database master key
In this recipe, we will create a database master key.
Getting ready
In this recipe, we will create a database master key for the master database. You can substitute a different database for this exercise if you wish.
The T-SQL equivalent of what we are trying to accomplish is as follows:
USE master GO CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'P@ssword'
How to do it...
Let's take a look at the steps required to complete the task:
- Open PowerShell ISE as an administrator.
- Import the
SQLPS
module and create a new SMO Server object as follows:#import SQL Server module Import-Module SQLPS -DisableNameChecking #replace this with your instance name $instanceName = "localhost" $server = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server ...
Get SQL Server 2014 with PowerShell v5 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.