Total Page Preview:   000000003181

How to Set client IP Address using the firewall security in Azure SQL Using Portal

In this article we will learn how to set or allow client IP Address  using the filewall security in Azure SQL database using Azure portal.

Step 1: Click on Azure Databases in Manu bar from the Azure portal. After you will get Azure database list which is given below screen:

Step 2: Click on Database > Overview given above screen shot. then you will get below screen:
Step 3: Click on Set Server firewall which is given above screen. After click above botton you will get all client ip address already set for the client in Azure firewall security which is given below screen.
Now Please enter the Firewall Rule Name, Client IP Adddres Start from and Client End IP Address which you want to set for the clients in azure sql server. After fill all  required data into the textbox then
please click on Save botton.

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn :


My spouse and I absolutely love your blog and find the majority of your post's to be exactly I'm looking for. can you offer guest writers to write content available for you? I wouldn't mind producing a post or elaborating on most of the subjects you write concerning here. Again, awesome website!
Link exchange is nothing else however it is only placing the other person's webpage link on your page at suitable place and other person will also do same in support of you.




Recent Posts

How to get the alternate rows or records from table in sql server
Data Warehouse Three Tier Architecture
SQL Server - Fragmentation on azure sql database
Limitations of Azure SQL Database
PIVOT and UNPIVOT in SQL Server with Example
SQL Server - Find unused indexes on azure SQL database scripts
SQL Server - Find all index with key columns on Azure SQL Database
Find Resource usage in Azure SQL Database using script or T-SQL
How to Set client IP Address using the firewall security in Azure SQL Using Portal
What are the types of User Define Function and difference between a nested UDF and recursive UDF in SQL server?
Top 16 performance query optimization techniques in SQL Database?
Top 60 SQL Server Interview Questions Answers for freshers and experienced
What is a Trigger and type of trigger in SQL server?
How many types of dimension tables available in data warehouse?
What are the differences between OLTP and OLAP?
Data warehouse Interview Questions Answers for freshers and experienced
What is Table Variable? Explain its advantages and disadvantages?
What are the different types of Error Handling in SQL Server?
Cloud Data Engineer SQL Server Interview Questions Answers for freshers and experienced
What are characteristics and advantages of stored procedure?

Facebook User: