Configure Microsoft SQL Always Encrypted

perform the following tasks to configure this integration 1 | generate column master key (cmk) open microsoft sql server management studio connect to the sql server open your database, and go to security > always encrypted keys > column master key right click and select new column master key in the new column master key window, enter a name and select key storage provider (cng) in the key store drop down list select futurex cng in the select a provider drop down list select \[ generate key ] your key appears in the window after creation select \[ ok ] to save and close 2 | generate a column encryption key (cek) under the same database, go to security > always encrypted keys > column encryption key right click and select new column encryption key enter a name for the key then, select the cek you generated in the previous section in the drop down list select \[ ok ] to finish 3 | encrypt columns with fxcng under the database, expand tables right click on the table you want to encrypt and select encrypt columns in the always encrypted wizard, on the introduction page, select \[ next ] in the column selection page, select the columns you want to encrypt, select the encryption type , and set the encryption key to the cek you generated in the previous subsection then, select \[ next ] in the master key configuration page, select \[ next ] in the in place encryption settings page, select \[ next ] in the run settings page, select proceed to finish now , and select \[ next ] in the summary page, select \[ finish ] when the encryption is complete, a green checkmark displays next to performing encryption operations you can view additional information by selecting always encrypted wizard log report select \[ close ] to finish view the encrypted columns to view the clear data for encrypted columns, perform the following steps to enable encryption in the server management studio launcher open microsoft sql management studio go to the always encrypted tab select the enable always encrypted (column encryption) checkbox connect to the server with the administrative user you used to configure always encrypted when you run your first query, a dialog box appears, prompting you to enable parameterization select either \[ enable ] or \[ close ] you can modify this setting later under query > query options > advanced query your encrypted table the encrypted data displays in plain text