Overview
If you use Microsoft OLE DB Provider for SQL Server (SQLOLEDB) provider for external database connections, e.g. for Reporting and Data Export, and want to have secured connection with TLS 1.2, the connection does not work and you will get error in Windows Event log from M-Files:Unspecified error. ([DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error. (ERROR: 18, SQLSTATE: 08001))
Solution
Microsoft has deprecated Microsoft OLE DB Provider for SQL Server (SQLOLEDB) and do not provide TLS 1.2 encryption for that provider. Instead, you should use Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) that supports TLS 1.2. The recommended providers for external database connections:Provider Recommendations for External Database Connections
