© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
M. McGiffenPro Encryption in SQL Server 2022https://doi.org/10.1007/978-1-4842-8664-7_7

7. Setting Up Always Encrypted

Matthew McGiffen1  
(1)
Bristol, UK
 

It is a straightforward process to set up everything required for Always Encrypted. In fact, there is a wizard provided in SQL Server Management Studio (SSMS) that will do it all for you. In these examples, however, we will focus on performing the individual steps manually as that gives you a better view of what is going on. For all the objects involved we’ll look in detail at what is created so that you have a good level of understanding.

Before starting it is best to make sure that the version of SSMS you ...

Get Pro Encryption in SQL Server 2022: Provide the Highest Level of Protection for Your Data 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.