Book Image

Learn Microsoft Azure

By : Mohamed Waly
Book Image

Learn Microsoft Azure

By: Mohamed Waly

Overview of this book

Azure is one of the leading public cloud service providers. Thanks to a number of Azure service updates, it continues to make advances in the realm of cloud computing. Learn Microsoft Azure starts with the fundamentals of cloud computing. You will learn to configure and set up the Azure infrastructure. As you make your way through the book, you'll explore Azure services, along with working on virtual memory systems (VMS) and deployment models. You will understand various services in the Azure ecosystem, such as Azure IoT and Azure Analytics, among others. An easy-to-follow introduction to various cloud design patterns will also add to your efficiency in designing cloud solutions. In the concluding chapters, you'll secure your virtual networks using Network security groups and configure Azure Active Directory (Azure AD) to set a custom domain name and company profile. By the end of this book, you will have learned to secure and troubleshoot your Azure cloud environment and be fully aware of best practices for Azure cloud administration.
Table of Contents (14 chapters)

Connecting to Azure SQL Database

As mentioned earlier, when you create an Azure Database via the Azure portal, all Azure services will be allowed to access this database with no further configuration.

However, when you want to connect to the database from anywhere else, there is some configuration that needs to be done.

Server-level firewall

To allow access to Azure SQL Database from somewhere else, you will have to set a server-level firewall rule, as described in the following steps:

  1. Navigate to the SQL Server and select Firewalls and virtual networks, as shown in the following screenshot:

  1. Then, you can specify the range of IP addresses you would like to allow access for, but if you want to specify a single IP address...