Active Roles cannot connect to SQL server where only TLS 1.2 is enabled
说明
One of the ARS nodes stays in "Getting Ready" until it fails with the following error:
原因
Affected Active Roles instance is using "SQL Native Client 11.0" (SQLNCLI11) when it should be using "Microsoft OLE DB Driver for SQL Server" (MSOLEDBSQL) instead. SQL Native client 11.0 is a deprecated provider so it’s not supporting the recent cryptography settings like Ciphers, Protocols or Cipher suites.
解决办法
Workaround: Change the Provider to "MSOLEDBSQL".
Click here for instructions to install the SQL client.