Database.ca SQL Server Blog

My Blog

Monday, October 28 2013

Keywords: Azure, SQL, SQL Azure, Cloud, Microsoft, Connecting to SQL Azure from SSMS, SQL Server Management Studio

Get Up & Running on SQL Azure in Less Than five Minutes!

You could open up a free trial SQL Azure account in two ways. The best option would be through your MSDN account. Otherwise if you do not have an MSDN subscription then you could open a Free Azure account online. You could easily find a link for that on Microsoft Azure site.

 

Azure, SQL, SQL Azure, Cloud, Microsoft, Connecting to SQL Azure from SSMS, SQL Server Management Studio

To activate your free Azure account through MSDN:
 
First login to MSDN, then navigate to MSDN Subscription page, then click on "Access Benefits" and finally click on "Activate Windows Azure". Go ahead and activate your Azure account. You’ll get a message “This subscription has a spending limit on it. Click here to change this setting.” Just ignore it and keep things the same. You do want your account to have a spending cap while you are trying things out.

 

Azure, SQL, SQL Azure, Cloud, Microsoft, Connecting to SQL Azure from SSMS, SQL Server Management Studio

Click on your MSDN account or Azure account...to see the details of your account...But all fun in is in your Azure control panel...and for that you would need to click on "Portal" on top right hand side of screen.

 

Azure, SQL, SQL Azure, Cloud, Microsoft, Connecting to SQL Azure from SSMS, SQL Server Management Studio

Click on "SQL DATABASES"

 

Azure, SQL, SQL Azure, Cloud, Microsoft, Connecting to SQL Azure from SSMS, SQL Server Management Studio

Fill in the required information, such as database name, and the collation. The collation you see list on the photo is the default Microsoft one nowadays. Select Web edition for the tests, and 1 GB should suffice for now. You don't want the incurred charges to run up too high. Since you do not have a SQL Server instance that you have used yet, go ahead and select "New SQL database server".

 

Azure, SQL, SQL Azure, Cloud, Microsoft, Connecting to SQL Azure from SSMS, SQL Server Management Studio

Your database will now be created . Click on the name of your database on the Databases list.

 

Azure, SQL, SQL Azure, Cloud, Microsoft, Connecting to SQL Azure from SSMS, SQL Server Management Studio

You will be presented by:

 

Azure, SQL, SQL Azure, Cloud, Microsoft, Connecting to SQL Azure from SSMS, SQL Server Management Studio

You will be advised whether or not your current IP address is already in Azure’s allowed list. If it is not, then you must first add it. Now launch SQL Server Management Studio (SSMS) and put in the required information to login.

 

Azure, SQL, SQL Azure, Cloud, Microsoft, Connecting to SQL Azure from SSMS, SQL Server Management Studio

Success!

 

Azure, SQL, SQL Azure, Cloud, Microsoft, Connecting to SQL Azure from SSMS, SQL Server Management Studio

 

Written by Ramin Haghighat