Deployed database to Azure using SSMS 2016 is not accessible inside web portal -


i used microsoft sql server management studio 2016 deploy database azure , went ok no problem , managed create database on azure imported database not visible outside azure sql server(web portal) standalone resource , when try access within azure sql server complains : "access denied".

enter image description here

what difference between database , 1 create using web portal? if create database in web portal visible standalone resource in resource group importing management studio makes visible inside sql management studio. should add special permission management studio newly imported database make visible inside web portal?

enter image description here

  • update 1 : realised behaviour happens when choose uk south region. west-europe databases can created , accessed using both web portal , ssms no problem.
  • update 2 tried creating database in north europe region , did not have problem either. issue needs resolved uk-south region sql azure team.

you correct, there configuration issue period sql databases created in azure uk south or uk west regions via t-sql (such via ssms), via old portal, or via older service management apis or powershell may not have been visible in azure management portal (portal.azure.com). affected databases online , accessible applications throughout. issue has been resolved , impacted customers notified. taking steps improve validation of configurations prevent recurrence of this. apologize inconvenience.


Comments

Popular posts from this blog

unity3d - Rotate an object to face an opposite direction -

angular - Is it possible to get native element for formControl? -

javascript - Why jQuery Select box change event is now working? -