Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted December 10, 2015

Exploration of SQL Server 2016 Always Encrypted – Part 2 - Page 2

By Greg Larsen

Exporting Certificate from Security Admin’s SQL Server 2016 machine

Next I exported the certificate, still playing the Security Admin role.  I did this by running mmc.exe from the command prompt on my Security Admin machine.  When I ran the mmc.exe the following window was displayed:

Export the Certificate
Export the Certificate

On this window I expanded the “File” menu option and then selected the “Add/Remove Snap-in”.  When I did this the following window was displayed:

Add or Remove Snap-ins
Add or Remove Snap-ins

Here I clicked on the Certificate item and then clicked on the “Add>” button.  When I did this the following window was displayed:

Certificates Snap-in
Certificates Snap-in

On this window I clicked on the “Computer Account” radio button and then clicked on the “Next>” button.  When I did this the following window was displayed:

Select Computer
Select Computer

Here I verify that the “Local Computer” radio button was selected and then I clicked on the “Finish” button.  When I do this the following window is displayed:

Add or Remove Snap-ins
Add or Remove Snap-ins

On this screen I just clicked on the “OK” button.  When I do that the following window is displayed:

Console Root > Certificates (Local Compter) > Personal > Certificates
Console Root > Certificates (Local Compter) > Personal > Certificates

On this window I expanded the “Console Root” node and the other nodes and then clicked on the “Certificates” item under the “Personal” item.  When I did I was able to see the “Part2_Demo” certificate I created with the makecert command above. 

‘Part2_Demo’ Certificate
‘Part2_Demo’ Certificate

I then right clicked on the “Part2_Demo” certificate, hovered over “All Tasks” item and then select the “Export” item.  Upon doing that the following window was displayed:

Certificate Export Wizard
Certificate Export Wizard

On this screen I clicked on the “Next” button.    When I did this the following screen was displayed:

Certificate Export Wizard – Export Private Key
Certificate Export Wizard – Export Private Key

Here I selected the “Yes, export the private key” radio button and then clicked on the “Next” button, which brought up the following window:

Certificate Export Wizard – Export File Format
Certificate Export Wizard – Export File Format

On this window I just took the defaults and clicked on the “Next” button.   Upon doing that the following screen was displayed:

Certificate Export Wizard - Security
Certificate Export Wizard - Security

Here I checked the “Password” checkbox and then entered a password twice and then clicked on the “Next” button.  When I did this the following screen was displayed:

Certificate Export Wizard – File to Export
Certificate Export Wizard – File to Export

On this screen I typed in a location where I wanted my exported certificate to be stored and then I clicked on the “Next” button.  This brought up the following completion window:

Certificate Export Wizard – Completing the Certificate Export Wizard
Certificate Export Wizard – Completing the Certificate Export Wizard

Here I reviewed the settings and then clicked on the “Finish” button.  When I did this I got a message box that stated ”The export was successful.” 



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM