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