Location - Choose an available location that will be more suitable for our requirement.

Once we enter all the "Server" details then Click on "Select".

Pricing Tier

Select an appropriate pricing tier for our requirement.

Collation

Create a name for the Collation (Collation defines the rules that sort and compare the data and cannot be changed after the database creation ).

Click on "Create" to provision the database.

Database provisioned successfully!! Go to the Dashboard and Click on the Sql Database ( "AzureSqlDB" ).

Now open the details page of SQL database ( "Overview" ). Here, we can see the Server name and other created details. We can access the SQL Database through this Server name in Azure Portal & Local MSSQL.

Create a server-level firewall rule

We need to setup a firewall rule for accessing our Azure Sql database in Azure Portal. So the SQL Database service creates a firewall at the server-level that prevents external applications and tools from connecting to the server. If we not set up any firewall rule in Azure SQL database portal, then we will get the following error.

Setup Firewall Rule

Click on the "Set server Firewall" in the Overview Section.

The "Client IP address" automatically fetched into the Firewall Setting. We just copy the IP Address and Add the START IP & END IP Section (This will add based on more than one IP address ). Set a "RULE NAME" of our Firewall. Once it’s all done then the information saves automatically into the firewall rule section.

SQL Database Login in Azure Portal

Click on the "Query editor ( preview)" and Click on the "Login" and it will display a Login portal for accessing our Azure SQL Database in Azure. So give or appropriate database credential into it. Once it’s done Click on "OK" button.

Output 1

It will open our Azure Sql Database Query Editor window with Database details.