How to enable encryption after SQL Server has been installed (Network Utility)
Note If you want to use encryption with a failover cluster, you must install the server certificate with the fully qualified DNS name of the virtual server on all nodes in the failover cluster. For example, if you have a two-node cluster, with nodes named test1.redmond.corp.microsoft.com and test2.redmond.corp.microsoft.com and a virtual SQL Server "Virtsql", you need to get a certificate for "virtsql.redmond.corp.microsoft.com" and install the certificate on both nodes. You can then check the Force protocol encryption check box on the Server Network Utility to configure your failover cluster for encryption.
To enable encryption
- On the Start menu, point to Programs/Microsoft SQL Server, and then click Server Network Utility
- If Multiprotocol does not appear under Enabled protocols, click it under Disabled protocols, and then click Enable. Otherwise, skip to Step 3.
- Under Enabled protocols, click Multiprotocol, and then click Properties.
- Select the Enable encryption check box.