Wednesday, July 17, 2013

3 Connect to Windows Azure SQL Server

Windows Azure is the Microsoft answer to the Amazon AWS.

Since Amazon AWS does not offer the SQL Server enterprise edition and Windows Azure does. So I decided to give the Azure a try.

The interface is quite simple .  Click the “CONNECT” button, this would invoke the Remote desktop and allow us to connect to the VM directly.

 

image

Connect to SQL Server from SSMS

1. Get the host name : Host name is under DNS Session

2. Setup the End Point

image

3. Setup the SQL server authentication

4. The most important thing is to setup the firewall rule

image

If firewall rules is not setup, we would get the below error while connecting to the SQL server from SSMS.

image

3 comments:

  1. There is a chance you're qualified for a complimentary $1,000 Amazon Gift Card.

    ReplyDelete
  2. More replica watchesthan the home of the legendary Royal Oak,replica audemars piguet Royal Oak Offshore, and Renaud et Papi’s grand complications, Audemars Piguet is the largest Swiss watchmaking brand still owned and guided by members of the original founding families.

    ReplyDelete
  3. Il y a aussi une fenêtre de date. fausse omega planet ocean montres Plant Ocean. Le cadran de cette montre comporte quelques marqueurs surdimensionnés et de grandes ...

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates