Issue while using SQLCompare against Azure SQL DB

I’ve encountered an issue while trying to compare a local SQL Server database against an Azure SQL DB using Redgate SQLCompare. When trying to specify my credentials, I got the following error: “Unable to load adalsql.ddl”.

Following that link actually leads you to a helpful page, where you can download the Active Directory Authentication Library for SQL Server. However, during set-up I got the following message:

Ugh. What you need to do is go to Control Panel and remove the program from the list, then re-install it again. Problem fixed! Keep in mind you cannot use the dropdown to select the database when connecting to Azure SQL DB, you need to type in the database name yourself. Otherwise you get this error:

The reason behind this is that you cannot connect directly to the master database in Azure.


------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂

Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.