Azure SQL - Login failed for user
<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>