Azure SQL Database

Create and use Azure SQL database

INTRODUCTION Azure SQL Database

Azure SQL Database is a relational database-as-a service using the Microsoft SQL Server Engine. SQL Database is a high-performance, reliable, and secure database you can use to build data-driven applications and websites in the programming language of your choice, without needing to manage infrastructure. This platform as a service.

STEPS to create Azure SQL DB

Login to Azure Portal (portal.azure.com) and you see the below page.

1. Click the New button found on the upper left-hand corner of the Azure portal.
2. Select Databases from the New page, and select Create under SQL Database on the New page.

Fill the required details like database name, select your subscription, resource group.

If you want copy of adventurework db then you select from select source dropdown.

Click on server which will open server details menu where you can fill in server details or select an existing one and click select. one filled everything then click on create. 

Azure created the database for you with given admin user details.

Before accessing server from management studio please make sure either firewall is off in Azure SQL server or your public ip is whitelisted. (you can use http://www.ip-adress.eu/ for your ipv4).

Now you can connect from management studio and typein the below

Server Name :- <servername>.database.windows.net

User:- Admin

Password:- <Password>