Adding a certificate to SQL Server
To add a certificate to SQL Server:
 |
We recommend you use a commercial certificate that is signed by a trusted Certificate Authority.
|
1. Start SQL Server Configuration Manager.
2. In the left pane, expand SQL Server Network Configuration.
3. Right-click on Protocols for <Instance_Name>, and then click Properties. The Properties window appears.
The default <Instance_Name> is MODELER.
4. On the Flags tab, under General, change Force Encryption to Yes.
5. Click on the Certificate tab.
6. Select the certificate that you want to use from the drop-down list, and then click OK.
If the certificate you that you want to does not appear, do the following:
a. Open the certificate file that you want to use.
b. Click on the details tab, and then copy the certificate Thumbprint value.
c. Start the Windows Registry Editor, and then navigate to the following key:
SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server\MSSQL12.MODELER\MSSQLServer\SuperSocketNetLib
If you not using the default SQL Server instance, replace MODELER with the name of your current instance.
d. Replace the data for the Certificate value with the Thumbprint value that you copied in step b.
7. Click on SQL Server Services and restart the SQL Server service: Right-click on the SQL Server instance, and then click Restart.