Skip to content

5000+ Great Articles

Best Articles & Essays: Interesting Articles to Read Online

  • Best ti multiview calculator 2020

    Best ti multiview calculator 2020. 1 - Texas Instruments TI-30XS MultiView Scientific Calculator (Renewed) Top Reviews .... . 2 - Texas Inst

  • How to Add Shapes in Google Docs 2021 Google Software/Tips
  • 5 Apps Parents Can Use To Spy On Their Children’s Internet Use Software Reviews
  • How To Encrypt & Decrypt a Text File In Windows 10 Windows 10
  • Best ti 84 calculator case 2020

    Best ti 84 calculator case 2020. 1 - Graphing Calculator Carrying Case for Texas Instruments TI-84 Plus CE, Fintie Hard EVA Shockproof Travel Protec

  • How To Check Your Router For Malware How-To
  • How To Stop Edge From Running in the Background How-To
  • Common Reasons for Ubuntu Crashes and How to Recover Linux Tips

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 Restore a Deleted Mailbox with PowerShell How-To
  • 10 Ways To Boost a Weak WiFi Signal How-To
  • 7 best 3D scanning apps for Android and iOS How-To
  • Editing videos for iPad Pro in 2023 How-To
  • How To Set Up Dual PC Streaming With No Capture Card How-To
  • How to Set Up Volume Controls on the 2019 Shield TV Pro and Tube? How-To

Leave a Reply Cancel reply

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

Archives

  • 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
  • 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
  • Male Models With Onlyfans – OnlyFans Sites Online!
  • 1Win Güncel Giriş Adresi 1Win Engelsiz Yeni Giriş
  • 4 Things You Can Do If You Forget Your Wi-Fi Password
  • How To Use DriveDroid to Boot Linux On PC Using Android
  • How do I Find Release Date of Any Google Play App
DMCA.com Protection Status

Recent Posts

  • 12 Most Common Android Problems and Their solutions
  • Male Models With Onlyfans – OnlyFans Sites Online!
  • Access Windows Shared Folder From Android Over Wi-Fi
  • 21SEIKI石巻中里【石巻市】 ベラジョンカジノの入金方法を徹底解説【2023年最新版】
  • ベラジョンカジノで大勝ちを狙えるゲーム10選 4,000万円以上稼いだ強者も!? CASINO JUICE カジノジュース

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 Disable annoying “headphone Jack Plugged In” Popup on any ASUS Laptop How-To
  • Best watch calculator 2020 Calls
  • How To Create a Windows 10 Installation USB Stick Windows 10
  • How To Play Pokemon Games On PC Gaming
  • Install and Setup a Website in IIS on Windows 10 Windows 10
  • Where To Find Themes For Google Slides

    Besides PowerPoint, Google Slides templates can get it from here. Google Slides has grown in popularity over the past few years and is not going to

  • Best credit card size calculator 2020

    Best credit card size calculator 2020. 1 - Gorilla Supply 50 Thermal Paper Rolls 2-1/4 X 50 Verifone Vx520 Ingenico ICT220 ICT250 FD400 50/CS

  • How to Play Gameboy Games on iPhone Without Jailbreak How-To

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Go to mobile version