{"id":250,"date":"2012-06-19T05:37:45","date_gmt":"2012-06-19T05:37:45","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/06\/19\/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\/"},"modified":"2012-06-19T05:37:45","modified_gmt":"2012-06-19T05:37:45","slug":"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","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/06\/19\/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\/","title":{"rendered":"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."},"content":{"rendered":"

When you try to connect to SQL Azure you get the error :
\nLogin failed for user ‘username’.
\nThis 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)<\/strong><\/p>\n

[xml]
\nTITLE: Connect to Server
\n——————————<\/p>\n

Cannot connect to tcp:xxxxxxxxxx.database.windows.net.<\/p>\n

——————————
\nADDITIONAL INFORMATION:<\/p>\n

Login failed for user ‘username’.
\nThis 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)<\/p>\n

For help, click: http:\/\/go.microsoft.com\/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476<\/p>\n

——————————
\nBUTTONS:<\/p>\n

OK
\n——————————
\n[\/xml]<\/p>\n

Fix\/Resolution:<\/strong>
\n– Check if the server name is correct.<\/p>\n

– Check if the user name, password is correct.<\/p>\n

– Try using the username as server@username.
\n If server is xxxxxx.database.windows.net then try with username xxxxxx@username<\/strong> <\/p>\n

– Check if you are able to connect to the SQL azure server using the below link:
\nhttps:\/\/servername.database.windows.net\/?langid=en
\nIf xxxxxx.database.windows.net is the server name then try to login by using the link
\nhttps:\/\/xxxxxx.database.windows.net\/?langid=en<\/p>\n","protected":false},"excerpt":{"rendered":"

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. ——————————…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[87],"tags":[2151,2152,2153,2154,2155,2156],"class_list":["post-250","post","type-post","status-publish","format-standard","hentry","category-sql-azure","tag-azure-error-18456","tag-azure-microsoft-sql-server-error-18456","tag-login-failed-for-user-this-session-has-been-assigned-a-tracing-id","tag-sql-azure-login-failed-for-user","tag-this-session-has-been-assigned-a-tracing-id","tag-this-session-has-been-assigned-a-tracing-id-of-provide-this-tracing-id-to-customer-support-when-you-need-assistance"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/250","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=250"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/250\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}