Skip to content

5000+ Great Articles

Best Articles & Essays: Interesting Articles to Read Online

  • How To Delete An Instagram Account How-To
  • Best hp prime graphing calculator 2020

    Best hp prime graphing calculator 2020. 1 - HP 50g Graphing Calculator Top Reviews Why I Like the 50g* The ControversyIf

  • 6 Programs for Beginners to Create Your Own Video Games Software Reviews
  • How to Watch a Video in Picture in Picture Mode on Mac How-To
  • How to Prevent Shutdown of a Windows Computer Computer Tips
  • How To Sign a PDF File Online Computer Tips
  • The Characteristics of How to Calculate Vat Inclusive in United States Computer Tips
  • How to Boost and Increase Your Internet Speed Cool Websites

Enable Encryption for Microsoft SQL Server Connections

Posted on October 9, 2020 By bilal 1983 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:

  • Facebook
  • X
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

  • How to Download Images from Google Docs How-To
  • How to Remove Background Noise in Skype Calls How-To
  • How To Remove Viruses Before Your Operating System Starts How-To
  • Free HQ Images You Can Use Without Linking to Source How-To
  • How to Encrypt USB Drive Using VeraCrypt How-To
  • Protect Your Facebook Account From Hackers (2017) How-To

Leave a Reply Cancel reply

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

Archives

  • December 2023
  • November 2023
  • October 2023
  • 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

  • – 436
  • – 939
  • 1Win AZ Bonuslar, Mobil Tətbiq və Mərc Marketləri – 376
  • 1xbet Azerbaycan,1xbet az merc saytı, en yaxsi bukmeker 1xbet Azerbaycan merc oyunlari, 1xbet az, Azerbaycan merc saytlari – 280
  • 1xBet giriş, güzgü 1 xBet Azərbaycanda rəsmi sayt – 413
  • AI Tools & Guides
  • Amazon Web Services
  • Apple Watch
  • B1 Bet Aviator: Jogo de Cassino Online Tutorial Passo a Passo 202 – 14
  • blog
  • Calculator
  • Computer Tips
  • Cool Websites
  • Dasinmaz emlak elanlari, ev elanlari, ev alqi satqisi, kiraye evler, torpaq, obyekt, bina, bina ev, mənzil, villa, kreditle satilan evler – 814
  • 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
  • Tutorial
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • Windows 7
  • Windows XP Tips
  • Wordpress
  • бонусы до 250%, официальный сайт в Узбекистане – 69
  • Мостбет Уз Ставки на спорт и казино в букмекерской конторе Mostbet Uz – 527
  • ベラジョンカジノの出金方法一覧【2023年 最新】出金限度額・出金の流れ・出金手数料・出金条件 – 466
  • How to Convert a Screenshot to a Jpeg on a Mac
  • Angie Brand – Best OnlyFans Nudes!
  • How to Listen to YouTube with Screen OFF (Android & iOS)
  • Discover the thrill of a foot fetish hookup
  • (no title)
DMCA.com Protection Status

Recent Posts

  • How to Convert Video on Android with FFmpeg Using Termux
  • Onlyfans Cuckold Wife – Try Online Beautiful-Nudes
  • Now Upload Photos To Instagram From Computer Without any Software
  • Samsung email not showing images? Try These 3 Fixes Now
  • 5 ways to check an image for copyright

Recent Comments

  1. Instagram stories not working/loading? Try These 9 Fixes on Can’t update PS5 system software? Try These 10 Fixes
  2. How to Link to a Specific Part Of A Webpage & Share it on Best PDF to Word Converter Online (Free Without Email)
  3. See What’s Taking up Space on Your Hard Drive on 7 best 3D scanning apps for Android and iOS
  4. Make your Devices Read Out Text, With Text to Speech on 9 Best 10K Running Apps for 2023
  5. How to Find your Router’s IP Address on How to Fix Apple CarPlay Not Working? 7 Possible ways
  • How to Install Kodi on Android Smartphones
  • How to locate a lost cell phone that is turned off Computer Tips
  • How to Create Your Own Onion Site on Tor How-To
  • How to Retrieve Archived Emails in Gmail How-To
  • How To Import Data Into Google Sheets From Another Sheet How-To
  • How to Remotely Sign Out of Chromebook How-To
  • Rumors, Lies and army apft calculator

    Rumors, Lies and Army Apft Standards,apft calculator.army apft regulation.army apft calculator. Download Standards of Medical Fitness in pdf.army apf

  • 7 best 3D scanning apps for Android and iOS How-To

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Go to mobile version