We have enabled ssl encryption on SQL Server in our environment. Currently application is able to connect to SQL Server with/with out valid certificate. Understand that SSL/TLS are for encryption purpose, but is there a way that SQL Server can reject the connection if the client certificate is not valid or connections without any certificates?
I can see the connections are encrypted using sql command, but not sure our implementation is correct as clients with/without valid certs are able to connect. Do we need to enable any feature to reject connections without valid certs?
Regards.
Varun