Creating a SQL database in Microsoft Azure portal

1) Open http://portal.azure.com/.

2) Start a free trial there. Put your email and password and get in. You will see
the below screen.

3) Click on “All resources”

Azure_Blog1_1

4) Click on “Add”,

Azure_Blog1_2

5) Click on “Databases” and then “SQL Database”.

Azure_Blog1_3

6) Click on “Sign Up for a new subscription” and selected as shown in the below screenshot,

Azure_Blog1_4

7) Provide details about you and get the Azure Subscription.

8) Once you have the subscription in place, Perform steps 3 to 5 again.

9) Below screen comes up once you click on “+Add”, “Databases” and then “SQL Database”. Click on “Server” and provide all details related to the server and click “Select”.

Azure_Blog1_5

10) You will see a screen like the below. Click on “Server” and in this case I have selected “Basic” instead of default “Standard” for cost reasons and Click “Apply”.

Azure_Blog1_6

11) Click on “Create” now. Wait for the deployment to complete,

Azure_Blog1_7

12) Once the deployment completes. Click on “All Resources” and you will see the “SQL serve” and the “SQL Database” as shown in the screenshot below,

Azure_Blog1_8

13) Click on the “SQL Database” and you will see the “Server name” and “connection strings”.

Azure_Blog1_9

14) Click on “Set server firewall” and add the IP addresses of machines that will be accessing the SQL server. Incase there are ipaddresses from 1.2.3.56 to 1.2.3.678, you can basically put that in START IP and END IP. Click on Save.

Azure_Blog1_10

Azure_Blog1_11

15) Open SQL server management studio and type the server name. Select “SQL server Authentication” and use the login that you created in step 9. In my case I created login “JBAdmin”.

16) Below is what I see,

Azure_Blog1_12

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.

Leave a Reply