Since we don't know whether you need TLS 1.2 support, the new driver is disabled by default.
4, the Alloy Navigator installer checks for MSOLEDBSQL during the installation or upgrade process, and installs it if necessary. This driver must be installed and enabled on all computers that access the SQL Server hosting the Alloy Navigator database.
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 SQLOLEDB driver ships as part of Windows Data Access Components, but it does not support TLS 1.2. īy default, Alloy Navigator uses the Microsoft OLE DB Provider for SQL Server (SQLOLEDB) to access SQL Server. INFO: For details on Microsoft’s recommendations, see. 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. Under Database Connection, select the Enable TLS 1.2 support check box.Ĭlick Test Connection to verify the connection. Log in to any Alloy Navigator desktop app installed on your computer (for example, the Desktop App or Settings) to reveal the Log in to Alloy Navigator window and click Manage Connections to start the Connection Manager. Enable the MSOLEDBSQL driver on your computer:.However, you can download it from the Microsoft Download Center at. In most cases, the driver has been already installed automatically.
Install the MSOLEDBSQL driver on your computer. When the MSOLEDBSQL driver is missing, install it (Steps 1) and then enable (Step 2). When the MSOLEDBSQL driver is disabled, just enable it (Step 2). this error occurs when the MSOLEDBSQL driver is not installed on your computer. The OLE DB provider ProviderName is missing or installed incorrectly. Please check with your Alloy Navigator administrator that your Database Access Key is valid." To view the particular error, click Details in the Error window.Ĭannot open the database connection. NOTE: This error message is a particular case of this generic error message: "Database connection failed. SSL Security error - this error occurs when the MSOLEDBSQL driver on your computer is disabled. This driver is required for Alloy Navigator when the SQL Server hosting the Alloy Navigator database uses Transport Layer Security (TLS) 1.2 for secure communication. Causeīoth errors are due to a disabled (or perhaps missing) Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL). The OLE DB provider is missing or installed incorrectly. SSL Security errorĬannot open the database connection. When you attempt to connect to Alloy Navigator, one of these error messages may appear: Microsoft OLE DB Driver for SQL Server is disabled or missing Symptoms