Click here to Skip to main content
13,088,846 members (62,239 online)
Click here to Skip to main content
Add your own
alternative version


11 bookmarked
Posted 17 Nov 2009

Connectivity to SQL Azure in Microsoft SQL Server 2008 R2 November CTP

, 17 Nov 2009
Rate this:
Please Sign up or sign in to vote.
Microsoft SQL Server 2008 R2 November CTP - Database Engine feature #1


I'm enjoying the weekend, with Microsoft SQL Server R2 November CTP and its new features from Database engine features to Analysis Services features, Reporting Service features, etc...

I'll post a series about those features en shaaa ALLAH in the next days, but let's begin with Database engine features #1 connectivity to SQL Azure: what's SQL Azure? is a cloud-based relational database service built on SQL Server® technologies. To learn more about SQL Azure press here


First you need to have Microsoft SQL Server R2 November CTP, get all about it from here and SQL Azure account (I got it from Microsoft Connect)

How to connect to SQL Azure


Open SSMS, and using your Azure account (Server name, username and password) try to login


And if it's your first time to use SQL Azure you'll get that


Then you should configure SQL Azure to accept connections from your IP, go to and select your project or create a new one


Select firewall settings to set your IP allowed to Access SQL Azure


Enter the rule name make it meaningful to be easy for your to manage, IP range, here's I select my IP I don't want anyone to access else me


Important note, don't run to SSMS to login, it just take some minutes from 2-5 minutes to apply changes.


Try now


Congrats, you're now connected -have problem till now?- please contact me Open new query window, create database, objects using T-SQL... you just need to create your database


Then close this query window to create objects inside "FirstDatabase" database you should refersh server databases and select "FirstDatabase" then new query Window, because USE Database not supported.




Version 1.0 submitted 17th November 2009.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Ramy Mahrous
Software Developer LINK Development
Egypt Egypt
Business Intelligence Developer at LINK Development which is a wholly subsidiary of LINKdotNET, graduated from Faculty of Computers and Information | Helwan University, Cairo, Egypt | 2003 - 2007, Computer Science as a Major, he has a passion for community, latest knowledge delivering and Q&A forums.

You may also be interested in...


Comments and Discussions

GeneralUpload pictures to codeproject Pin
Mike Lang18-Nov-09 10:45
memberMike Lang18-Nov-09 10:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.170813.1 | Last Updated 17 Nov 2009
Article Copyright 2009 by Ramy Mahrous
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid