May 25, 2023 at 2:57 pm
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]
GO
SELECT DISTINCT (encrypt_option)
FROM sys.dm_exec_connections;
GO
I get:
encrypt_option
FALSE
TRUE
May 26, 2023 at 3:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
May 31, 2023 at 10:37 am
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