title: Create file DSN for an Azure database
body: <p>I want to connect an Access form with an Azure SQL Server Database. In order to do that I have to create new <code>File DSN</code> (because I want this data source to be used on all the machines and not only mine).</p>
  
  <p>When I try to do this from the Administrative tools, I cannot even connect to SQL Server on Azure using my SQL credentials. I get this error :</p>
  
  <pre><code>Connection failed:
  SQLState: '28000'
  SQL Server Error: 18456
  [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user xxxx
  </code></pre>
  
  <p>The credentials are correct because:</p>
  
  <ol>
  <li>I am able to connect to the database using SSMS with the same credentials</li>
  <li>I get no errors when I try to do the same thing with <code>User</code> or <code>System</code> DSN. But I don't want this because I want to share the data source with all the machines.</li>
  </ol>
  
  <p>Any ideas please?</p>