I'm having difficulties with connecting to my deployed database on Azure. I'm new to Azure, currently trial license. I have a web application created in ASP.NETCore C# with Visual Studio 2015 (still in debug phase). It's already deployed and running. I have a database attached to it and data can be saved with no issues.
However, I cannot connect to it in no way. That means that I cannot modify it and cannot apply migrations. I need to delete it from Azure portal and create a new one, then when I publish my app from VS everything works fine. Before, when I tested my app on a local server I applied migrations through console. setting up in appsettings appropriate connection string. Now when I copy a connection string from Azure it gives me an error. The same error as in SSMS open image I cannot ping to it, nor access through telnet. I used tracert and it stops here open image. In Azure I set a firewall to put through my ip adress as well as a maximum possible range. My port 1433 is tested and there is a connection according to grc.com.
It irritates me, because I cannot even open it in SSMS. How is this possible? Does anyone have an idea, what else can I do? Maybe I'm doing something wrong, in an official tutorial from Azure it looks so easy, but doesn't work for me. I'll be glad to see any ideas.