title: SQL Server deploy database to Azure throws "You must have a user with the same password..."
body: <p>I have a live SQL Server database which was originally on an Express version and has compatibility 100. I am inspecting it using SSMS 2016 RC, which seems to have highest compatibility level of 120.</p>
  
  <p>On performing the task <code>Deploy Database to Microsoft Azure SQL Database...</code> it goes through all the verification steps and then bails out with the error:</p>
  
  <blockquote>
    <p>Could not import package. Unable to connect to master or target server X. You must have a user with the same password in master or target server X</p>
  </blockquote>
  
  <p>Is the only solution to upgrade the compatibility version of the database and is that even possible from such an old level? Do I have to install a newer SSMS to do this?</p>
  
  <p>I've seen a similar question below, but it refers to SSDT, not SSMS:
  <a href="https://stackoverflow.com/questions/46735814/ssdt-failing-to-publish-unable-to-connect-to-master-or-target-server">SSDT failing to publish: &quot;Unable to connect to master or target server&quot;</a></p>