Azure Sql Database and access it by practical

Description:

In software development, we knew how to create an SQL Database in local machines and how to access it, here we are going to see how to create an SQL Database from Azure then how to access it from development machines / laptop.

Prerequisite:

Knowledge of Ms Sql Server
Anyone browser

Below steps we are going to follow, here I'm going to use Edge browser but, if you wish you could use any browser

Sign in on www.azure.com from the home page click Create a resource
In the next window, click Create under Sql Database
From the project details click Create new under Resource Group now a popup will appear there type the name as RG-SqlDb click Ok
Next, Under Database details, type the Database name as sqlDbDemoJ then click Create new under Server then a new page opens up there

Server name as jsqldbserverdemo
Location as West Europe (you can take any location)
Authentication method as Use SQL Authentication
Server Admin Login as adminj
Password, confirm password as our wish then click Ok

Want to use elastic pool as No
Workload environment as Development
Click Configure Database under Compute + Storage, in the next screen choose Serverless from Compute tier
Hardware Configuration let it be Standard-series(Gen5)
Data max size (GB) is 2 since it's our demo DB so, I have chosen less size
The rest of the configs are let it be and click Apply button
From the main page click Review + create from the final page tab click Create
Now, azure has started to validate our choices and create the resources, it will take less than one minute so, please wait, the beauty here is we could see the estimated cost on the right side
After successful creation we could see the page like below there click Go to resource button
From the resource page, on search location type Connection there click on Connection String this will show the connection string details with multiple providers so, I choose Ado.Net
Now I want to connect this Db from my laptop so, so I use SSMS to connect but, it gives the below error
It's because now we know server data source, user id, and password but, in azure we are blocked to access this DB due to firewall settings so, go back to the azure portal there click Set server firewall
Under Public access click Selected networks then under Firewall rules click +Add your client ipv4 address then azure automatically takes your current IP and creates a rule like below, if we want then we can change the rule name then click Save
Now again, from my laptop using SSMS I tried to connect the Azure Sql DB and I'm able to connect and I have created one table as well