title: Azure SQL Database Create via bacpac Import Fails
body: <p>We are testing the migration from a local SQL Server 2008R2 database to Azure, but have hit a bump in the road.</p>
  
  <p>Process followed, based on SO articles:</p>
  
  <ul>
  <li>Installed SQL Server 2012 Client tools</li>
  <li>Amended DB to remove indexes with a fill factor specified, as well as invalid views and procedures (this was determined by using the Export Data-tier Application tool for SSMS, until it successfully created bacpac file)</li>
  <li>uploaded the successfully created bacpac file to Azure</li>
  <li>Went through steps to create new database using import method</li>
  <li>bacpac file is retrieved from blob storage status shown, but then the following error occurs</li>
  </ul>
  
  <blockquote>
    <p>BadRequest ;Request Error;Error Status Code:&lt;/B&gt;
    &#39;BadRequest&#39;&lt;/P&gt;&lt;P&gt;&lt;B&gt;Details:
    &lt;/B&gt;Error encountered during the service operation. ; Exception
    Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unable to
    authenticate request; &lt;/P&gt;&lt;/DIV&gt;&lt;/BODY&gt;&lt;/html&gt;</p>
  </blockquote>
  
  <p>Note: error text above was trimmed to exclude URL's as I don't have sufficient points.</p>
  
  <p>I can't seem to find any info on this error or where there may be any additional log details to help determine why it will not import.</p>
  
  <p>As the error mentions unable to authenticate, we also tried doing the following:</p>
  
  <ul>
  <li>Created a new user and password on the local DB</li>
  <li>Used this same new user and password for the definition of the new DB on Azure</li>
  </ul>
  
  <p>This did not make any difference.</p>
  
  <p>Would appreciate if someone could point us in the right direction to get this working, as we would need to replicate this process quite a few times.</p>
  
  <p>Thanks.</p>