Applies to: Windows Hosting Servers, MSSQL-based sites and connections
Please note: If the site in question is hosted in our Shared hosting environment, you will need to open a Support ticket for assistance.
If your site uses the SQLOLEDB provider for a specific module or database, you may see something similar to the following error in DNN after migrating to a new Windows server or disabling TLS 1.0 and TLS 1.1:
An error has occurred. DotNetNuke.Services.Exceptions.ModuleLoadException: [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error.
This is due to the SQLOLEDB provider not supporting TLS 1.2. If TLS 1.0 and TLS 1.1 are not present or enabled on the server it will break the provider's function, causing an error to appear. To resolve this, Microsoft has published the MSOLEDSQL driver, which features backwards compatibility with SQLOLEDB and can be used as a replacement. To do this,
download the driver from Microsoft and install it to the server, then change the connection string provider from SQLOLEDB to MSOLEDBSQL and recycle the site's application pool.
Article ID: 2847, Created: May 29, 2020 at 2:14 PM, Modified: May 29, 2020 at 3:03 PM