Creating SQL Database on Microsoft Azure

 

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

 

Login to Azure Portal or Manage Azure Portal

From Azure Portal

image

 

From Manage Azure Portal

image

 

Create Database

image

 

image

 

image

 

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

image

 

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

Under Auditing and Security, select image  *Show security enabled Connection String.This will popup Security Enabled Connection strings.At the bottom of page you will see image .Click firewall rules. There you can define the IP Ranges.

 

image

 

image

Connecting Azure SQL Database from local SSMS.At database portal page, under Connect to your database.The database url will be displayed.

 

image

 

Connect using the url with username and password which you supplied at the time of database creation

 

image

0 thoughts on “Creating SQL Database on Microsoft Azure

Leave a Reply

Your email address will not be published. Required fields are marked *