SQL SERVER – Introduction to SQL Azure – Creating Database and Connecting Database

I recently logged into new Azure Portal and I really think the product team has done excellent job to make it user-friendly and self intuitive.

Here are the quick steps I have done after I logged into the portal here:

  • Purchased subscription
  • Created Server
  • Created Database
  • Connect using Database

Honestly it is that simple. Here is the screen representations of the same.


Here you can specify your current IP address in start and end range. This way only from your IP you can connect to the server.

I have noticed that one developer kept the IP Range Start: and IP Range End: so he can connect to the database from any IP in the world. I strongly advise against this as this can be really big security issue for you.

Now you can directly connect to your Azure using [Writeyourservername].database.windows.net.

You can connect using either Azure Portal or SSMS.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQLAuthority News – Pluralsight On-Demand FREE for SQL Server Course
Next Post
SQL SERVER – 2012 – Executing Stored Procedure with Result Sets

Related Posts

No results found.

5 Comments. Leave new

  • hello pinal sir,
    how r u?, its gud for an overview of SQl azure. i wanna know, as a DBA how sql azure is help full or if it has a different path from Data base administration thn shud we prefer to go with this sql azure, hows the carrer wid tht.?

    sachin soni

  • Thanks for sharing this information, azure looks pretty cool. I am going to check this one.

  • HI Sachin,

    You can connect to SQL azure from your home (if you have internet and if you IP is added in the azure portal ).

    You can connect to the SQL DB (Onpremise) if you have your office domain or network.

    As of now SQL Azure DB is limited to 50 Gb for the Business and Azure team is going to incresae the space by Nov 2011 in the portal.

    If you have SQL azure in place , no need of High availability concepts like Replication,clustering,logshipping and Mirroring in SQL DB.You have Data sync API which will sync the data between your onpremise db and the azure db.

    You can change/allocate the space required for your db at any time from the azure portal.

    You can connect to the SQL Azure with the SQL authentication only.

    Your SQL Azure will not be down until or unless if the region where your azure subscrption is held.So you data will be available always.

    We do have few limitataions in SQL Azure like you may not able to do the query in the cross db.

    Please let me know if you need any more information.

    Dilip Reddy

  • Excellent program! Very easy to use.

  • not getting the pics


Leave a Reply Cancel reply

Exit mobile version