Introduction


This article walks you through the steps for creating an Azure SQL Database using the Azure Platform Management Portal. Below are the steps

 

Create Azure Account


You need to get a Azure account. Everyone can open an Azure account for free.

Check the link below for more information.

http://www.windowsazure.com/en-us/pricing/free-trial/

  



Create SQL Database on Azure


After get access to an Azure Account, we need to create a SQL Database to store your data.

So for that we need to select the option New on the left bottom of our web page and then select the option Data Services -> SQL Database-> Quick Create and give a name to your SQL Database and provide credentials.

On this case our SQL Database will have the name "SQLDBDemo".


  


On the middle of installation, the user need to answer if it want's to give the IP of server to the firewall rules.

To access to the database from external programs (web application for example) the rule needs to be added to the firewall rules.


 

After the creation, a new server was created with our database SQLDBDemo, as you see on the next image.

 


 

If we select the database, we get access to the information of our database.


  
 

Each SQL Database server has a fully qualified unique domain name, such as servername.database.windows.net. The servername refers to the name of your SQL Database server. You can use the fully qualified DNS name to build connections strings for your database. The following are two example connection strings based on this example database.

ADO.NET:
        
Server=tcp:gctnlrc0ei.database.windows.net,1433;Database=SQLDBDemo;User ID=spadmin@gctnlrc0ei;Password= your_password_here};Trusted_Connection=False;Encrypt=True;Connection Timeout=30;

        
ODBC:
        
Driver={SQL Server Native Client 10.0};Server=tcp:gctnlrc0ei.database.windows.net,1433;Database=SQLDBDemo;Uid=spadmin@gctnlrc0ei;Pwd={your_password_here};Encrypt=yes;Connection Timeout=30;

 

 

The connectivity test could be made from an SQLServer or Visual Studio Server Explorer.

Enter the admin user name and password that you created when setting up the SQL Azure database. 

For the host, enter the fully qualified DNS name from the SQL Azure connection details displayed in the SQL Azure control panel. The port can be left blank or enter 1433. 

The database name is the name you gave to the SQL Azure database during the create database process performed above. 

Assuming your local IP address or a range containing your local IP address was entered as a firewall rule in the SQL Azure control panel, the connection should be successful.

 



Azure Resources

Some good resources about Azure could be found here: