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
0 thoughts on “Creating SQL Database on Microsoft Azure”