In my previous blog I discussed about solving the SSL Security error: SECCreateCredentials(). After solving this error when I resumed my CRM installation, another similar error pop up again. But this time it was SSL Security error: SECDoClientHandshake()
This error looked quite familiar as I already read before in one of the Microsoft Support article. Since I knew this was a known error, still I tried to follow up the steps to simulate the SQL server connection error via Microsoft OLE DB Provider using a *.UDL file.
- Open Notepad
- Save the file as ‘Connectivity Test.udl’ and file type as ‘All Files’
- Open the saved file
- Select Microsoft OLE DB Provider for SQL Server as the provider
- Provide server connection and authentication details
- Test the connection or open list of databases
- The connection fails with same error message
Reason was quite clear: This fails because the secured connection between the Dynamics CRM Server 2016 and the SQL Server needs TLS 1.0 to be enabled for the OLE DB Provider for SQL Server. And the SQL Server may not have TLS 1.0 enabled for secure channel communication
As the suggested resolution, I opened the regedit and checked the TLS 1.0 status which by default Enabled was Set to 0 and DisabledByDefault was set to 1
I enabled the TLS 1.0 under both the Client and the Server folders by settings the Enabled to 1 and DisabledByDefault to 0
Once updated, I tested the OLEDB connected again with the ‘Connectivity Test.udl’ file and the error was gone; connection was successful. I then resumed back my CRM installation and it completed without any further errors.
Hope that was helpful. Thanks !