When you try to connect to SQL Azure you get the error :
Login failed for user ‘username’.
This session has been assigned a tracing ID of ‘xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx’. Provide this tracing ID to customer support when you need assistance. (Microsoft SQL Server, Error: 18456)
[xml]
TITLE: Connect to Server
——————————
Cannot connect to tcp:xxxxxxxxxx.database.windows.net.
——————————
ADDITIONAL INFORMATION:
Login failed for user ‘username’.
This session has been assigned a tracing ID of ‘xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx’. Provide this tracing ID to customer support when you need assistance. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
——————————
BUTTONS:
OK
——————————
[/xml]
Fix/Resolution:
– Check if the server name is correct.
– Check if the user name, password is correct.
– Try using the username as server@username.
If server is xxxxxx.database.windows.net then try with username xxxxxx@username
– Check if you are able to connect to the SQL azure server using the below link:
https://servername.database.windows.net/?langid=en
If xxxxxx.database.windows.net is the server name then try to login by using the link
https://xxxxxx.database.windows.net/?langid=en