AlwaysOn Availability Groups and Encrypted Channels

by J.D. Walker   Last Updated May 16, 2019 04:06 AM

If I want to implement both AlwaysOn Availability Groups and Encrypted Channels, how would I do this?

There is a desktop application (Visual Studio 2008 built) that interacts with this database, and the client wants traffic between the application and the database encrypted. They also want redundancy in the database.

Tags : sql-server


Answers 1


You can simply enable SSL on each replica as per normal, but the certificate you provision should have a CN that matches the Listener name that you're connecting to.

See here for more info.

HandyD
HandyD
May 16, 2019 03:45 AM

Related Questions


Updated September 03, 2018 18:06 PM

Updated March 16, 2016 08:02 AM

Updated July 10, 2018 15:06 PM

Updated April 17, 2019 14:06 PM

Updated April 18, 2019 11:06 AM