For more information on encrypted connections with the database engine, see this Microsoft article.
-
In SQL Server Configuration Manager, expand SQL Server Network Configuration, right-click Protocols for <server instance>, and then select Properties.
-
In the Protocols for <instance name> Properties dialog box, click the Certificate tab.
-
In the Certificate box, select the certificate you want, and then click OK.
-
On the Flags tab, in the Force Encryption box, select Yes, and then click OK to close the dialog box.
-
Restart the SQL Server service.