title: Azure SQL - Login failed for user
body: <p>I am using a free azure subscription, have set up an SQL server (v12) and created a database onto it.</p>
  
  <p>However i cant seem to log in using the server admin credentials that i set when prompted during the SQL server credentials.</p>
  
  <p>Management Studio returns:</p>
  
  <pre><code>Cannot connect to &lt;server name&gt;...Login failed for user 'mickey'
  
  SQLCMD -S &lt;servername&gt;.database.windows.net -U mickey@servername -P pass -q "select 1"
  </code></pre>
  
  <p>Returns</p>
  
  <p><strong><em>Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : Login failed for user '</em></strong></p>
  
  <p>Is there something i am missing? Been at this for hours</p>