Search BrianLoesgen.com
Categories
Archives
Saturday
Oct032009

Connecting to SQL Azure with SQL Server Management Studio

This morning I decided this was something I wanted to do. So, I BINGed around and saw others had already been down this path. However, their techniques didn’t work for me (this is still a CTP, change is certain, and perhaps that’s why). Eventually, I connected, and thought I would do a post here for the benefit of others who may have similar issues.

As has been stated, you need to cancel out of the initial connection dialog box you get when you start Management Studio, and then choose New Query to get a connection dialog. If you don’t do that, you will not be able to connect.

Some key points about my dialog below:

  • Server name: this is the FQDN (do NOT include the “tcp:” prefix the Azure portal shows in the connection strings for server name)
  • Login: this is just my user name as shown in the connection string on the portal (and not <username>@<servername>) as most posts show
  • Click the Options button an type in the name of the database you want to connect to

 

image

After doing that, if all goes well, you’ll get the following dialog, which you can ignore.

image

 

After I did that, I was able to do this:

image

Some more notes:

  • As Richard points out here, you need to specify a clustered index, or table creation will fail
  • As Ramaprasanna says here, most problems people have are firewall issues

 

Hope this help. Now that I’ve successfully flexed this brand new capability, I’m going to brainstorm with myself about what cool things I can do with it, like oh maybe using it to add value to BizTalk ESB scenarios…

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>