How to Create a Windows Azure SQL Database

Edited by Malakzia, DeepForest, Anna, Laura and 1 other

This wikiHow article show you how to create a Windows Azure SQL Database. Also it shows you how to connect to database from your app.

1
Log in to your Windows Azure management portal.

Ad
2
Click on the NEW button in the bottom left corner.
Then, it will show you a wizard.
3
Choose Data Services from the first pane, then select SQL Database.
4
Select Quick Create.
- It will show a dialog, to enter name, select server and data center’s region for your database.
5
Enter the name for your database, and choose New SQL database server in the SERVER if you don’t have any.
6
Choose a login name which will be your username to access the database. Enter a strong password to meet the following requirements.
- The password must meet the following requirements:
  - More than eight characters in length
  - Does not contain all of the login name
  - Contains characters from at least three of the following categories:
    -English uppercase characters (A through Z)
    -English lowercase characters (a through z)
    -Base 10 digits (0 through 9)
    -Non-alphanumeric characters (example: !, $, %)
7
Click Create SQL Database. Then you will see the following process.
When the process is completed, you will see your database name in "'all items"' list in management portal. Now your database is created successfully!

1
Manage firewalls. To allow your client app to connect to your database, you need to add client pc’s IP address to allowed list. To do so -
- Click on SQL Databases in management portal. You will see a list of current databases in your Management Portal.
2
Click on Cars database.
3
Click on Dashboard in menu.
4
Click on “Manage allowed IP addresses” link in Quick Glance.
5
Click on Add to the Allowed IP Address against your current client IP Address
6
Click on Save button in the bottom bar.
- Now you are done managing your database connectivity settings. You can now connect your database to your client app.

1
Copy Connection String from your Cars database Dashboard. To do so -
- Go to Dashboard and click Show Connection Strings in Quick Glance.
- Copy the ADO.NET Connection String
  and replace {your_password_here} with the password your entered in credentials of database.
- Make a simple console application in Visual Studio and enter this code in the Main() function.
- Collapse | Copy Code
  try
  {
  Console.WriteLine("Creating Connection");
  var conn = new
  SqlConnection(/* CONNECTION STRING HERE */ );
  var cmd = new
  SqlCommand("Select * From Manufacturers", conn);
  Console.WriteLine("Opening Connection!");
  conn.Open();
  Console.WriteLine("Connection
  Opened");
  Console.WriteLine("Executing Query");
  var result =
  cmd.ExecuteReader();
  Console.WriteLine("Query Executed!");
  Console.WriteLine("Manufacturers found in database:");
  while
  (result.Read())
  {
  object[]
  rowArr = new object[result.FieldCount];
  result.GetValues(rowArr);
  Console.WriteLine("\t"+rowArr[1]);
  }
  Console.WriteLine("Closing Connection!");
  conn.Close();
  }
  catch (Exception ex)
  {
  Console.WriteLine("Error
  Occured\n"+ ex.Message);
  }
  Console.Read();
2
Run the application.
- It gives the following output, which means that everything is running OK and the SQL query is run against the server successfully, returning the rows of data.
Ad

Article Info

Categories: MySQL

Recent edits by: Laura, Anna, DeepForest

Thanks to all authors for creating a page that has been read 337 times.

Was this article accurate?

Yes No

How to
Create a Network Based ID Card Project with ID Card Workshop and Microsoft SQL (MS SQL) Databases

How to
Create a Database in MySQL

How to
Back Up and Restore Data in MySQL

How to
Add Data to a Mysql Database One Line at a Time

How to
Teach Your Child Sight Words

How to
Highlight Text in a PDF Document

How to
Diagnose Gallstones

How to
Improve Cyber Security in Small Organizations

Meet Laura, a wikiHowian from Ohio who has been on the site over 3 years. She has started 88 articles, many of which have been chosen as Rising Stars, and she has made over 9,900 edits on the site. She is a Featured Author, and her favorite ways to help out are patrolling recent changes and formatting articles. The first article she worked on for wikiHow was How to Create a Signature With Pictures in Outlook Express in Windows Vista, but her favorite articles to work on have been those related to caring for people with dementia and to parenting teens, for which she’s used her own experiences as a guide. She loves how the people in the wikiHow community jump to help each other with edits and problems. Her advice to new contributors is to take your time to get to know all the tools and to invest your energy and heart into writing well-researched, quality how-tos.