Azure SQL - Login failed for user

Question

I am using a free azure subscription, have set up an SQL server (v12) and created a database onto it.

However i cant seem to log in using the server admin credentials that i set when prompted during the SQL server credentials.

Management Studio returns:

Cannot connect to <server name>...Login failed for user 'mickey'

SQLCMD -S <servername>.database.windows.net -U mickey@servername -P pass -q "select 1"

Returns

Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : Login failed for user '

Is there something i am missing? Been at this for hours

Answer 1

It could be the password contains a few special characters that sqlcmd does not handle (such as dollar, single or double quote, parentheses). I tried using the Azure interface and surrounding the password with single-quotes (we had a dollar-sign in the password), but that did not work. So, we simply removed the special character and now it is OK. see: Powershell Invoke-Sqlcmd Login Failed and https://mohitgoyal.co/2017/08/09/vsts-azure-sql-database-deployment-task-keeps-failing-with-error-login-failed-for-user/