Encrypting a connection from SQL Server Management Studio

Step 1: Download mssql3_key.zip or mssql2_key.zip to your computer and extract the .cer file to a directory.

Step 2: Install the certificate.

• Double click the file mssqlx_key.cer and select 'Install Certificate'
• Click 'Next'.
• Select 'Place all certificates in the following store'
• Browse and select 'Trusted Root Certification Authorities'
• Click 'Next'
• Click 'Finish'

Step 3: Run SQL Server Configuration Manager

• Right click on SQL Native Client Configuration
• Select 'Properties'
• Change 'Trust Server Certificate' to YES

Step 4: On the Object Explorer toolbar in SQL Server Management Studio

• Click 'Connect'
• Click 'Database Engine'
• In the Connect to Server dialog box, complete the connection information
• Click 'Options'
• On the Connection Properties tab click 'Encrypt Connection'

Add Feedback