Skip to content

5000+ Great Articles

Best Articles & Essays: Interesting Articles to Read Online

  • How to Connect to a Remote or Local Server on a Mac OS X
  • Why It’s So Hard to Recover Deleted Data on Android and What to Do About It Smartphones
  • How to Convert Multiple Images to One PDF Document on PC How-To
  • Best hp 12c platinum financial calculator 2020

    Best ti 84 graphing calculator case 2020. 1 - HESPLUS Compatible with Graphing Calculator Texas Instruments TI-84/83/Plus CE Hard EVA Shockproof Carrying Cas

  • How to Set Up and Use MLA Format in Microsoft Word MS Office Tips
  • Add Bookmarks Toolbar Button to Google Chrome How-To
  • Turn Off Indexing in Windows for Better Performance Computer Tips
  • How to Add Music to iMovie 2023 Tutorials

Enable Encryption for Microsoft SQL Server Connections

Posted on October 9, 2020 By blog_786 No Comments on Enable Encryption for Microsoft SQL Server Connections

It’s late afternoon and I just got a very interesting assignment. A client of mine wants to connect to their Microsoft SQL Server over a public network without a VPN, and he asks me how we can best secure this connection. The first thing that crossed my mind was encryption!

So I told him that let’s enable encryption of traffic going through port 1433 so that we can minimize this giant loophole, which is directly related to accessing Microsoft SQL Server over the public network.

Enable Encryption for Microsoft SQL Server Connections

Now, to be able to even start the encryption setup process, we first need the most important of all: a certificate that has the following extended key usage property: Server Authentication 1.3.6.1.5.5.7.3.1.

Therefore, when deploying a self-signed certificate or buying a legitimate one, we need to additionally make sure that the key usage string is exactly the same as above. Now, 99% of the time, a self-signed certificate is sufficient for encryption, but you can get a valid one from a trusted vendor.

Enable Encryption for Microsoft SQL Server Connections

Ok, now that I’ve made sure I have the correct certificate, let’s go in and tell SQL which certificate to use. To do this, we need to copy the certificate fingerprint and enter the following registry key:

HKLM SOFTWARE Microsoft Microsoft SQL Server MSSQL14.MSSQLSERVER MSSQLSERVER SuperSocketNetLib

Enable Encryption for Microsoft SQL Server Connections

This particular key has a value called Certificate. We need to copy and paste the thumbprint of the certificate to this value.

In my case it will look something like this:

Enable Encryption for Microsoft SQL Server Connections

Now let’s go into SQL Server Configuration Manager, then go to SQL Server Network Configuration, under Protocols for MSSQLSERVER, go to Properties and then to Certificate tab. Here we will see the newly deployed certificate in the registry. All that remains is to select the certificate and restart the SQL Server service.

Enable Encryption for Microsoft SQL Server Connections

Enable Encryption for Microsoft SQL Server Connections

We will then move on to enforce protocol encryption by right-clicking on the native SQL client configuration and making sure the Forced Encryption option is set to Yes.

Enable Encryption for Microsoft SQL Server Connections

Now that we have configured the certificate, let’s go back to SQL Server services and restart the service by right-clicking on the SQL Server service (MSSQLSERVER) and choosing Restart.

Enable Encryption for Microsoft SQL Server Connections

Voila, we have now configured port 1433 to encrypt communications!

The next step is to configure encrypted connections in our application or in case of connecting from SQL Server Management Studio.

To do this in SSMS, we need to follow these steps:

  1. Click Connect to Database Engine.
  2. In the Connect to Server dialog box, go to Options
  3. On the Connection Properties tab, click Encrypt Connection.

That’s it, pretty simple and straightforward. I hope you enjoyed this article and hope you come back for more interesting articles.

Share this:

  • Twitter
  • Facebook
How-To Tags:Enable Encryption for Microsoft SQL Server Connections

Post navigation

Previous Post: Creating an SOFS Share on S2D using Virtual Machines
Next Post: Using Wireshark to Sniff an SMB transmission

Related Posts

  • 8 Best Free and Paid Cloud Storage (2017) How-To
  • How To Get Windows 10X File Explorer on Windows 10 How-To
  • How to Make Chrome Less Resource Intensive How-To
  • how to open CFD file on Windows and Mac step by step How-To
  • How to Check Battery Health on Windows and Android How-To
  • How To Change Your Skype Name How-To

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Archives

  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • November 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • March 2021
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • December 2019
  • July 2019
  • May 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018

Categories

  • AI Tools & Guides
  • Amazon Web Services
  • Apple Watch
  • Computer Tips
  • Cool Websites
  • Featured Posts
  • Free Software Downloads
  • Gadgets
  • Gaming
  • General Software
  • Google Software/Tips
  • Hardware
  • Help Desk
  • How-To
  • iOS
  • iPad
  • iPhone
  • islamic Books
  • Linux
  • Linux Tips
  • Mac OS X
  • macOS
  • MS Office Tips
  • Networking
  • Office Tips
  • OS X
  • Product Reviews
  • Reviews
  • Safari
  • Smart Home
  • Smartphones
  • Software Reviews
  • technology
  • text
  • Tools Review
  • Troubleshooting
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • Windows 7
  • Windows XP Tips
  • Wordpress
  • How to go Back to the old YouTube Layout (2017)
  • A Simple Trick to Get 50% Discount on Audible for Three Months
  • What Is “Other” Storage on Android And How to Clean It Up ?
  • 7 Legal Websites to Get Free Music Downloads
  • Six Copyscape Alternatives That you can use
DMCA.com Protection Status

Recent Posts

  • How to go Back to the old YouTube Layout (2017)
  • A Simple Trick to Get 50% Discount on Audible for Three Months
  • 6 Best PayPal Alternatives (2017)
  • How to Fix the the “Invalid SIM Card” Error on Android
  • What Is “Other” Storage on Android And How to Clean It Up ?

Recent Comments

  1. A Simple Trick to Get 50% Discount on Audible for Three Months on Private Browsing: What is it and What it is not
  2. 6 Best PayPal Alternatives (2017) on How to Save Money While Shopping Online in India
  3. Automatically Transcribe YouTube Video/Audio with Google Docs on 5 Best Team Management Apps (For Small and Large Teams)
  4. 6 Things You Need Know About Email Encryption on Delete All Emails from Gmail With Once Click
  5. Looking For YouTube Alternative? Try These 7 Video Sharing Sites on Ten Best YouTube Video Editing Software 2023
  • How To Turn Your Old Computer Into An Arcade Machine technology
  • Best Action Cameras Under $ 100 Dec 2020 Gadgets
  • Fix “Your PC’s CPU isn’t compatible with Windows 8/10” Error Windows 10
  • What is the best way to get channel points on twitch? Gaming
  • This Android App Lets You See Other Android App’s Trackers How-To
  • Best cx cas ti-nspire calculator 2020 T
  • How to Use Compare & Combine Documents in Word MS Office Tips
  • PopuPiano: The Smart Portable Piano Review Gadgets

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Go to mobile version