Home > Windows & SQL Server AZURE > Creating SQL Database on Microsoft Azure

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: