The following guide, will directly go through the steps in creating a SQL Server database in Microsoft Azure Cloud.
In Microsoft Azure Portal choose “Create a resource”:
Choose “SQL Database”
The following is a snapshot sample:
Choose “create” , I have chosen the pricing tier “Standard S0: 10 DTUs, 250 GB”
Deployment will be in progress….until you see the following successful message
Take note of your fully qualified server name !
To test your database connection to your created database:
The login account is the server admin account name you have choose before.
After successfully connecting successfully I have executed the select@@version query as shown below
I was able to access the database in Azure using SQL Server Management Studio, of course you need configure the firewall in azure portal to add your current client IP address:
sql server warrior 