External Error: Unable to load adalsql.dll (Authentication=ActiveDirectoryIntegrated). Error code:0x2. For more information, see http://go.microsoft.com/fwlink/?LinkID=513072

Created
October 08, 2021 23:17

Date Posted: 2019-12-09
Product: TIBCO Spotfire®

Problem:

Solution:

While connecting to the SQL Server Connector connection with Active Directory authentication method, you may get below error after clicking on the 'Connect' button:

==========================
Error: Could not connect due to an unknown error. External Error: Unable to load adalsql.dll (Authentication=ActiveDirectoryIntegrated). Error code:0x2. For more information, see http://go.microsoft.com/fwlink/?LinkID=513072
========================== Starting with Spotfire version 10.2, a new method of authentication has been introduced in SQL Server Connector: 'Active Directory- Integrated'. To resolve the above error message, follow the below steps:

You must have the following software installed on the computer that is running the Spotfire Analyst/Client and Node Manager machine:

1) .NET Framework, version 4.6 or later
2) Azure Active Directory Authentication Library for SQL Server (ADALSQL.DLL)]

The 'ADALSQL.DLL' file can be downloaded and installed from the link: https://www.microsoft.com/en-us/download/details.aspx?id=48742

Also, If you are using Active Directory and your domain is federated with Azure Active Directory, you can connect to Microsoft Azure SQL Database and authenticate with your logged in Azure Active Directory credentials. Select the authentication method Active Directory - Integrated. https://www.microsoft.com/en-us/download/details.aspx?id=48742