Azure Synapse Analytics - Creating Firewall At Server-Level

In this article, we’ll learn in a step-by-step process to create a firewall rule for specific client IP and virtual network in the Azure Synapse Analytics. This step is essential so that our server and databases are secure from any connection from external tools and applications. Moreover, connectivity is also secured for our Azure Synapse Service with this step.

This article is a part of the Azure Synapse Analytics Articles Series. You can check out other articles in the series from the following links.

1. Azure Synapse Analytics 
2. Azure Synapse Analytics - Create Dedicated SQL Pool 
3. Azure Synapse Analytics - Creating Firewall at Server-level 

Azure Synapse Analytics 

Azure Synapse is a limitless enterprise analytics service that enables us to get insight from data analytics and data warehousing. Using dedicated resources or serverless architecture, data can be queried and provides scalability as per the increase in the size of the data. You can learn more about it in the previous article, Azure Synapse Analytics. 

Firewall

Firewall can be understood as the set of security rules which determines, controls and monitors the ongoing traffic in a network and thus acts as a shield in between untrusted network and trusted network in a system connected to internet.

How to Create Firewall at Server-level for Client IP in Azure Synapse Analytics? 

Step 1 

First of all, we need to create a SQL pool following the previous article in this series, Azure Synapse Analytics - Create Dedicated SQL Pool. This enables the creation of Sample data specified in Step 7 in the article.

Step 2 

Once the sample database is created. Next we can create an easy access to Azure Synapse Analytics for future use.

For this, click on Menu button on the left-hand side and Select All Services.

Next, go select the Databases on the left-hand side and hover over Azure Synapse Analytics.

On the top right corner, click on the Favorite Button.

Now, we can see, we can access the Azure Synapse Analytics from the Favorites in the Menu.

Step 3 

Now, we can check out our resources.

Click on Go to Resources or you can just access the database from the favorites we just created.

Step 4 

Here, we can see the Server name, Connection Strings the other details. On the side of Server name, we can see the Copy Button using which we can connect this server to any services such as Azure Data Studio.

Step 5 

Next, Click on Show database connection Strings under Connection Strings.

Step 6 

Now, we are taken to the sql-server details we created under the name ojash-server.

Here, we can check out the Firewall settings. We check it out, Click on Show firewall settings.

Step 7 

Here, we switch the Allow Azure Services and Resources to Access this server to Yes. 

Next, we click on Add client IP.

Step 8 

We can see the Client IP Address added under the Rule Name and Start IP and End IP. This will open the Port at 1433 for this IP address to access the server.

Step 9 

Once, it is validated with the Tick Mark, click on Save.

Step 10 

We are verified with Success Dialog box.

Note
Make sure, the Yes is selected in Allow Azure service and resources to access this server. Otherwise, we cannot access this server.

Step 11 

Finally, we will be notified about the success in updating our server firewall rules. With this, we have successfully learnt to create a server rule for our client IP in Azure Synapse Analytics.

Conclusion 

Thus, in this article, we learned about Azure Synapse Analytics and about Firewall, and then we learned through a step-by-step process following up in the previous article to create a firewall for our SQL Server in Azure Synapse Analytics.