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.
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.
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.
Click on "SQL DATABASES"
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".
Your database will now be created . Click on the name of your database on the Databases list.
You will be presented by:
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.
Written by Montreal DBA Team