How to connect to the Azure Database?

5

Well friends, I have a database on Azure, but I can not connect to it. The error is that my IP is not allowed to make such a connection, what I did was add a new rule to the bank server firewall, but every moment I change IP I have this problem. What should I do to resolve this problem?

    
asked by anonymous 02.06.2015 / 22:46

1 answer

2
  • Log in to Azure;
  • In the database part, choose the database you want;
  • Choose "Manage";
  • Azure will tell you that you need to add an exception in the Firewall for your IP and ask for a confirmation. Confirm;
  • The next screen asks if you want to use the online editor to access the bank. From now on, the database can even be accessed by your local SQL Server Management Studio.
About always asking for every IP change, it's a security feature of the Azure service. It would only be possible to fix an IP in your database if it were hosted inside a virtual machine, for example, without this configuration of endpoints , which is mandatory in case of database hosting. / p>     
03.06.2015 / 00:20