I'm provisioning a new server as part of which we have disabled TLS1TLS 1.0 and installed SQL Server Express 2016. I've then attempted to install a 3rd party application whichthat is going to install a website and supporting DB etc. The first thing it does is test the connection to SQL which givesand it returns the following error:
Connection Problem: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error
To attempt to work out the issue I created a UDL file on my desktop and reproduced this error when using the Provider Microsoft OLE DB Provider for SQL Server, the. The test worked fine for provider SQL Server Native Client 11.0 or indeed usingand I can also connect with SSMS.
So isIs there anyway I can force the 3rd party installer to use a different provider? Is there anyway I can log what type of connection it is attempting?