了解客户端和SQL Server之间的协议通信！ [英] Understanding of protocol communications between Client and SQL Server!!
问题描述
Hi Professionals，
在我们的环境中，我们只在所有Windows服务器上启用TLS 1.2协议来强制执行高安全性标准。
<我们知道必须在SQL服务器和Windows上应用的修复程序，但是，很少有案例出现，也不确定如何解决这个问题。所以请帮助解决这个问题，以便更多地了解客户端和服务器通信。
1）在客户端计算机（应用程序服务器）上启用了SSL 2.0,3.0和TLS 1.0,1.1,1.2（所有协议），在SQL服务器上仅启用了TLS 1.2，此处选择了哪个协议用于通信？
2）这是case1的反向情况，在客户机（应用服务器）上只启用了TLS 1.2，在SQL服务器上有SSL 2.0,3.0和TLS 1.0,1.1， 1.2启用（所有协议），选择哪个协议进行通信？
谢谢!!
您好Nerendar：
此论坛致力于支持开放特定在
https://msdn.microsoft.com/openspecifications 上找到的图标。您的询问似乎与开放式规格无关。为了更好地获得回复，请将您的查询发布到SQL Server论坛。有大量的论坛专门为
提供SQL服务器配置的各个方面。以下链接适用于以下论坛：
https://social.msdn.microsoft.com/Forums/en-US/home?forum=sqlsecurity
Hi Professionals,
In our environment,we are enabling only TLS 1.2 protocol on all windows servers to enforce high security standards.
We are aware on the fixes that has to be applied on SQL server and windows,However, Few cases arised and not sure how this can be addressed.so please help on this matter to understand more on client and server communication.
1)On client machine(application server) SSL 2.0,3.0 and TLS 1.0,1.1,1.2 are enabled(all protocols) and on SQL server only TLS 1.2 is enabled,Here which protocol is opted for communication ?
2) this is reverse situation of case1,On client machine(application server) only TLS 1.2 is enabled and on SQL server SSL 2.0,3.0 and TLS 1.0,1.1,1.2 are enabled(all protocols),ere which protocol is opted for communication ?
Thank you!!
Hi Nerendar:
This forum is dedicated to supporting open specifications found at https://msdn.microsoft.com/openspecifications . Your inquiry does not appear to be related to open specifications. For a better chance of getting a response, please post your inquiry to SQL server forums. There is a large number of forums dedicated to various aspects of SQL server configuration. The following link is for one such forums:
https://social.msdn.microsoft.com/Forums/en-US/home?forum=sqlsecurity
这篇关于了解客户端和SQL Server之间的协议通信！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
