Support Portal

Welcome, Guest Login

Support Center

Microsoft SQL Server Communication Encryption

Last Updated: Mar 15, 2018 12:17PM PDT

Applies to...

  • DxEnterprise 15.0
  • DxEnterprise 15.5
  • DxEnterprise 16.0
  • DxEnterprise 17.0 for Windows
  • DxEnterprise 17.5 for Windows
  • Microsoft SQL Server

Summary

How to enable communication encryption with Microsoft SQL Server on DxEnterprise. For more details on setting up encrypted connections with Microsoft SQL Server see the MSDN article in the References section below.

Information/Steps

The certificate should be installed using the VHost name on each server that is a member of the VHost. Once that is complete, you should go to the server where the instance is active and modify the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\MSSQLServer\SuperSocketNetLib\Certificate

The registry is replicated to the instances SQL Data Root upon changes, so no further action is need to have the setting persist on failover or re-host to another server.

References

https://msdn.microsoft.com/en-us/ms191192.aspx

Contact Us

ef1ddaa4c6b21be8fdef1c5390754c94@dh2i.desk-mail.com
http://assets0.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete