Allow only encrypted connections.

  • Hi

    In SQL22, Is there a way to allow only / force encrypted connections?

    I have 'force encryption' on and have cert installed:



    But when I connect via SSMS I can unselect ' Encrypt Connection' and it connects. My understanding is that means that it is allowing non-encrypted connections:


    How do I make my SQL server not support non-encrypted traffic?

    If I run:

    USE [master]


    SELECT DISTINCT (encrypt_option)

    FROM sys.dm_exec_connections;



    I get:




    • This topic was modified 1 week, 6 days ago by  krypto69.
    • This topic was modified 1 week, 6 days ago by  krypto69.
  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Hi,

    is the SSMS on the same server like the sql server?

    And what kind of protocols are active on the sql server?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply