Configure SSL on a SQL Failover Cluster

Pre-Requisites

  • Have an SSL cert where the Common Name (CN) of the cert matches the name of the SQL instance that needs to have SSL enabled. A wildcard cert will also work.
  • Ability to modify the registry on each of the cluster nodes

Step 1 of 2 (Import the Certificate into Windows)

  • Hold down the Windows key and push R to open a run window
  • Type mmc.exe and hit enter
  • Click the File menu and select Add/Remove Snap-in…
  • Select Certificates from the left column and click Add >
  • Select Computer Account and click Next when prompted

Screenshot1

  • Click Finish
  • Click Ok

Read More