Error while installing CRM – Test connection failed because of an error in initializing provider. Login failed. The login is from untrusted domain and can’t be used with windows authentication

While installing CRM, I got the below error:

Test connection failed because of an error in initializing provider. Login failed. The login is from untrusted domain and can’t be used with windows authentication

My application was not able to connect to sql server. 

I checked the log and found below error :
“SSPI handshake failed with error code 0x80090346 while establishing a connection with integrated security: reason: channel bindings from client are missing or do not match established TLS channel. The service might be under attack, or the data provider or client operating systemmight need to be upgraded to support Extended protection. Client’s supplied SSPI channel bindings were incorrect”.
Things I tried/checked so far:

  1. Both client server and SQL server are in same domain.
  2. The user I use for connectivity test is local admin in both of the servers.
  3. The same user is database admin as well.
  4. All SQL services are up and running.
  5. In database server properties, “Allow remote connections to this server” is yes.
  6. In both of the servers, TLS 1.0, 1.1 and 1.2 is enabled.
  7. In SQL server configuration manager-> SQL server network configuration , all protocols (Shared memory, TCP and named pipes) are enabled.
  8. In SQL server configuration manager-> SQL server network configuration , I changed the order of protocols to 1. Shared memory 2. Named pipe 3. TCP/IP.
  9. 1433 port is open in SQL server
  10. In system’s local security policy -> Local policies-> User rights assignment -> Access this computer from network , administrator group is added.

 Then , I suspected this is due to force encrytion property in SQL server configuration manager.
Open SQL Server Configuration Manager :

Right click on SQL native client configuration -> Click on properties -> disable force encryption.
This solved my issue.