Require encrypted connections to MS SQL Server

How to require clients connecting to Microsoft SQL Server to use an encrypted connection.

First, the server must have a certificate.

Next, SQL Server must be configured to require secure connections  using the following steps:

  1. On the server running MS SQL Server, run SQL Server xxxx Configuration Manager

  2. Expand SQL Server Network Configuration

  3. Right click on the Protocols for <servername> and select Properties

  4. Certificate tab > choose the machine’s certificate

  5. Flags tab > Force Encryption > Yes

  6. OK

  7. Right click on SQL Native Client 11.0 Configuration and choose Properties

  8. Flags tab > Force Protocol Encryption > Yes

  9. OK

  10. Reboot the server

© 2023 Foray, LLC - All Rights Reserved