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.

Posted on : 19-06-2012 | By : Devi Prasad | In : SQL AZURE

1



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)

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
------------------------------

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




Reference : Devi Prasad (sqlserverlearner.com)

Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.



Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.




Your Ad Here


Tags: , , , , ,