Microsoft OLE DB Driver for SQL Server is disabled or missing

Introduced in 8.3

Updated in 8.5

Symptoms

When you attempt to connect to Network Inventory, one of these error messages may appear:

[DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error

Cannot open the database connection. The OLE DB provider [ProviderName] is missing or installed incorrectly.

Cause

Both errors are due to a disabled (or perhaps missing) Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL). This driver is required for Network Inventory when the SQL Server hosting the Network Inventory database uses Transport Layer Security (TLS) 1.2 for secure communication.

  • [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error — this error occurs when the MSOLEDBSQL driver on your computer is disabled.

    NOTE: This error message is a particular case of this generic error message: "Database connection failed. Please check with your Network Inventory administrator that your Database Access Key is valid." To view the particular error, click Details in the Error window.

  • Cannot open the database connection. The OLE DB provider ProviderName is missing or installed incorrectly. — this error occurs when the MSOLEDBSQL driver is not installed on your computer.

Resolution

When the MSOLEDBSQL driver is disabled, just enable it (Step 2). When the MSOLEDBSQL driver is missing, install it (Steps 1) and then enable (Step 2).

  1. Install the MSOLEDBSQL driver on your computer. In most cases, the driver has been already installed automatically. However, you can download it from the Microsoft Download Center at https://www.microsoft.com/en-us/download/details.aspx?id=56730.

  2. Enable the MSOLEDBSQL driver on your computer:
    1. Log in to any Network Inventory desktop app installed on your computer (for example, the Desktop App or Settings) to reveal the Log in to Network Inventory window and click Manage Connections to start the Connection Manager.

    2. Under Database Connection, select the Enable TLS 1.2 support check box.

    3. Click Test Connection to verify the connection.

    4. Click OK to exit the Connection Manager.

More information

Since some known vulnerabilities have been reported against earlier versions of Transport Layer Security (TLS 1.0 and 1.1), Microsoft recommends disabling these outdated TLS versions on your Microsoft SQL Server and using TLS 1.2 for secure communication.

INFO: For details on Microsoft’s recommendations, see https://support.microsoft.com/en-us/help/3135244/tls-1-2-support-for-microsoft-sql-server.

By default, Network Inventory uses the Microsoft OLE DB Provider for SQL Server (SQLOLEDB) to access SQL Server. This SQLOLEDB driver ships as part of Windows Data Access Components, but it does not support TLS 1.2.

If your SQL Server administrator has followed Microsoft's recommendations and upgraded to TLS 1.2 on the SQL Server, a new OLE DB provider, which is called the "Microsoft OLE DB Driver for SQL Server" (MSOLEDBSQL), is required. This driver must be installed and enabled on all computers that access the SQL Server hosting the Network Inventory database.

Starting with version 8., the Network Inventory installer checks for MSOLEDBSQL during the installation or upgrade process, and installs it if necessary. Since we don't know whether you need TLS 1.2 support, the new driver is disabled by default.

INFO: For details on the MSOLEDBSQL driver, see https://www.microsoft.com/en-us/download/details.aspx?id=56730.