Creating First Azure SQL Server Database
Logon to Azure Portal ..you will get Rs. 13,300 credits to use free azure account for 1st Month.
Goto Dashboard Window:
Select Create Resource
Select Database > SQL Database
Provide all Info: DB Name , Subscription, Select Source as Blank Database ,Resource Group : Create New, Server : Configure required setting –Create New Server > Server name > admin login > password >location
SQL Elastic Pool : Not now , Pricing Tier : Basic /standard/premium – charges as per DTU/month
Basic Selected Rs. 377/Month
Select Create
Deployment Submitted.
AzureTestDB created check other Server details like Server name xyz.database.windows.net
Next Step > Click Set Firewall
Click Add Client IP
Edit and add full range like below. This will allow you to connect to Azure SQL Server database from your Client Server which are in this range.
Client IP address added successfully.
You can query on your server
You can connect to Azure Sql server by using Server name xyz.database.windows.net and query on server.
