How do I connect using Active Directory integrated authenticiation?
When connecting to our Azure SQL server using SQL Compare's option for "Active Directory integrated authentication", I get this error message: Unable to load adalsql.dll (Authentication=ActiveDirectoryIntegrated). Error code: 0x2. For more information, see http://go.microsoft.com/fwlink/?LinkID=513072
I went to the URL and installed the software from Microsoft, restarted, and still get the same error.
Please note that SQL Server Management Studio (SSMS) is able to connect to this server using "Active Directory - Integrated" authentication method. Also, please note I can connect using SQL Compare's "SQL Server authentication" with a different account, but this account has different permissions and is not my desired account.
0 · Share on Twitter