A quick demo on how to create a SQL Database on Microsoft Azure.
From Azure Portal
From Manage Azure Portal
Accessing the database. Click the database name it will take you to the database page.
Under Auditing and Security, select *Show security enabled Connection String.This will popup Security Enabled Connection strings.At the bottom of page you will see .Click firewall rules. There you can define the IP Ranges.
Connecting Azure SQL Database from local SSMS.At database portal page, under Connect to your database.The database url will be displayed.
Connect using the url with username and password which you supplied at the time of database creation