{"id":3784,"date":"2020-04-01T15:03:49","date_gmt":"2020-04-01T15:03:49","guid":{"rendered":"http:\/\/himbap.com\/blog\/?p=3784"},"modified":"2020-04-01T15:03:49","modified_gmt":"2020-04-01T15:03:49","slug":"cannot-connect-to-your-azure-sql-db-logical-server-azure-sql-server","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=3784","title":{"rendered":"Cannot connect to your Azure SQL DB logical server- Azure SQL Server"},"content":{"rendered":"<p>Recently I setup Azure SQL Server from Azure portal UI and I wanted to access it from outside so I configured all required steps so that it is accessible remotely like following screen:<br \/>\n<a href=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/04\/azureImg.jpg\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-3790 aligncenter\" src=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/04\/azureImg-300x241.jpg\" alt=\"azureImg\" width=\"300\" height=\"241\" srcset=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/04\/azureImg-300x241.jpg 300w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/04\/azureImg-624x501.jpg 624w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/04\/azureImg.jpg 651w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>but still I was getting following error while trying to connect to Azure SQL Server from my machine:<\/p>\n<p><strong>Cannot connect to your Azure SQL DB logical server\/Azure SQL MI server, exception: Cannot open server &#8220;&#8230;..&#8221; requested by the login. The login failed.&#8221;<\/strong><\/p>\n<p>While troubleshooting this issues, luckily I found this <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-database-support-blog\/providing-the-server-name-explicitly-in-user-names-for-azure-sql\/ba-p\/368942\">post<\/a><br \/>\nBased on this post if you are getting this error, you can suffix <strong>@YourSQLServerName<\/strong> in your user name.<br \/>\nFor example suppose I am trying to access <strong>devssisdbserver.database.windows.net<\/strong> using following User: <strong>dev@himbap.com<\/strong> and getting above error.<\/p>\n<p>So to resolve this issue I have to suffix my sqlserver name after the user name, so I tried using<br \/>\n<strong>dev@himbap.com@devssisdbserver<\/strong> and it worked !<\/p>\n<p>Hope it will help someone !!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recently I setup Azure SQL Server from Azure portal UI and I wanted to access it from outside so I configured all required steps so that it is accessible remotely like following screen: but still I was getting following error while trying to connect to Azure SQL Server from my machine: Cannot connect to your Azure SQL DB logical server\/Azure&#8230; <a href=\"https:\/\/himbap.com\/blog\/?p=3784\">Read more &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[21],"tags":[750,746,747,748,749],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3784"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3784"}],"version-history":[{"count":6,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3784\/revisions"}],"predecessor-version":[{"id":3792,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3784\/revisions\/3792"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3784"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}