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:

    encrypt

     

    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:

    encrypt2

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

    If I run:

    USE [master]

    GO

    SELECT DISTINCT (encrypt_option)

    FROM sys.dm_exec_connections;

    GO

     

    I get:

    encrypt_option

    FALSE

    TRUE

    • This topic was modified 1 year, 5 months ago by  krypto69.
    • This topic was modified 1 year, 5 months 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