I have a SQL Server 2017 instance that I have configured to listen on multiple ports 1433 and 1234. I would like to know if its possible to have one port (1234) accept only secure connections while the default port accept both?
I have already set up the instance, verified both ports are working, and installed the certificate but it seems my only option is to force SSL for the entire instance in config manager. Am I missing something? All help is appreciated.
asked Feb 13, 2021 at 17:12
-
I'd love to know why you wouldn't just force encryption always.Charlieface– Charlieface2021年02月14日 05:06:25 +00:00Commented Feb 14, 2021 at 5:06
-
@Charlieface sadly there are some tightly coupled legacy applications that do not support encrypted connections. my initial hope was we could secure one port and leave the other port available to accept both secure and non-secure connections.deadLock– deadLock2021年02月15日 16:29:20 +00:00Commented Feb 15, 2021 at 16:29
1 Answer 1
Am I missing something?
No. "Force Encryption" is an instance-wide setting.
answered Feb 13, 2021 at 17:21
David Browne - Microsoft David Browne - Microsoft
49.2k3 gold badges53 silver badges102 bronze badges
Explore related questions
See similar questions with these tags.
lang-sql