Always encrypt connection from SQL Server Management Tool

According to Enable Encrypted Connections to the Database Engine (SQL Server Configuration Manager), you do this as such:

To configure the server to accept encrypted connections

1. In SQL Server Configuration Manager, expand SQL Server Network Configuration, right-click Protocols for , and then select Properties.
2. In the Protocols for Properties dialog box, on the Certificate tab, select the desired certificate from the drop down for the Certificate box, and then click OK.
3. On the Flags tab, in the ForceEncryption box, select Yes, and then click OK to close the dialog box.
4. Restart the SQL Server service.

To configure the client to request encrypted connections

1. Copy either the original certificate or the exported certificate file to the client computer.
2. On the client computer, use the Certificates snap-in to install either the root certificate or the exported certificate file.
3. In the console pane, right-click SQL Server Native Client Configuration, and then click Properties.
4. On the Flags page, in the Force protocol encryption box, click Yes.

_source

0 Votes

MagicallyDelicous
March 09, 2017 17:37 PM