A quick demo on how to create a SQL Database on Microsoft Azure.

 

Login to Azure Portal or Manage Azure Portal

From Azure Portal

 

From Manage Azure Portal

 

Create Database

 

 

 

Accessing the database. Click the database name it will take you to the database page.

 

Added the local IP address  or IP  range. For IP Range,Click .

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