TLS1.2 Cipher suites for AlawaysON Endpoint

Chinni 21 Reputation points
2022-05-03T19:10:08.39+00:00
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,329 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,126 Reputation points Microsoft Vendor
    2022-05-04T02:34:52.157+00:00

    Hi @Chinni ,

    When enabling channel encryption between the application and SQL Server, users may wonder what encryption algorithm is being used to protect their data. Unfortunately, this isn't an easy question to answer.

    A cipher suite is a set of cryptographic algorithms that specifies the algorithm for key exchange, encryption, and message authentication. What the best cipher suite to use is negotiated by SSL/TLS and depends upon the cipher suites supported by the OS on the client and the server. The client will provide the server with a list of its cipher suites from the negotiated protocol. The server will chose the strongest cipher suite that it is able to support from the client's list.

    Refer to below MS documents, hope these could help you.

    SSL Cipher Suites used with SQL Server
    Server cipher suites and TLS requirements
    Cipher Suites in TLS/SSL (Schannel SSP)


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".


0 additional answers

Sort by: Most helpful