title: Azure SQL Database connection using Active Directory Integrated authentication fails to open
body: <p>I'm attempting to connect to Azure SQL Database via Entity Framework with a connection string similar to this:</p>
  
  <p><code>Data Source=&lt;server&gt;.database.windows.net;Authentication=Active Directory Integrated;Initial Catalog=&lt;database&gt;</code></p>
  
  <p>The connection attempt is made within the context of a hosted WPF form running inside AutoCAD 2018. The project is built using .NET Framework 4.6 and EF 6.1.3.</p>
  
  <p>I'm encountering the following error:</p>
  
  <p><code>Unable to load adalsql.dll (Authentication=ActiveDirectoryIntegrated). Error code: 0x2. For more information, see http://go.microsoft.com/fwlink/?LinkID=513072</code></p>
  
  <p>Unfortunately the help link doesn't lead to page that provides technical details for this issue. I haven't so far discovered anything on the web elucidating the root cause.</p>
  
  <p>I've also tried this connection string:</p>
  
  <p><code>Server=tcp:&lt;server&gt;.database.windows.net,1433;Initial Catalog=&lt;database&gt;;Persist Security Info=False;User ID=&lt;username&gt;;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication="Active Directory Integrated"</code></p>
  
  <p>It was copied from the Azure portal's <code>ADO.NET (Active Directory integrated authentication)</code> section. However, with this connection string I get the following error <code>Cannot use 'Authentication=Active Directory Integrated' with 'User ID', 'UID', 'Password' or 'PWD' connection string keywords</code></p>
  
  <p>But it doesn't contain a password segment. And after removing the <code>User ID</code> segment, I still get the <code>Unable to load adalsql.dll ...</code> error.</p>