- SQL Azure – Creating SQL Azure Server and Database in Azure Management
- SQL Azure – Configuring SQL Azure so you can connect from Local SQL Management Studio
- SQL Azure – Creating SQL Azure Server and Database using PowerShell
- SQL Azure – Connecting to SQL Azure server and database using the browser
As I’ve recently started using SQL Azure recently at work, and although the steps are basic really to create a database and get up and running, I thought I would post a couple of “simple 101” blogs just showing you how. This first post of my SQL Azure series will show you the steps to create a SQL Azure Server and database using the good old “point and click” method.
- Open up the Management Azure Portal and log in using your username and password.
- Click on New > Data Services > SQL Database > Custom Create.
- On the dialog window, fill in the boxes.
- Give the database a name. This is the Database name not the server name. Azure will automatically assign the server name.
- At the bottom of the page, change the Server tab to New SQL database server, as soon as you do this a second page to the Wizard will appear.
- Click the next arrow.
- On the second page fill in the Database Server settings. You need to provide a Login name, password and region. The Login name can be anything you want, however think of this as your SA username and password. (E.g, SQLAdmin)
At the bottom of Page 2 wizard is two check boxes:
- Allow Windows Azure Services to Access the Server – With this ticked it allows you to connect to SQL Azure database from other Azure services (With the username and password). This means any Azure services including Azure services from a different tenant.
- Enable Latest SQL Database Update – This will give you the latest and greatest version of SQL Azure, sometimes this will be a preview version. At the time of writing this post, V12 was the latest update and it had better T-SQL compatibility. For example I know using V12 allows you to create a table that has no clustered index. This feature is especially helpful for its support of the T-SQL SELECT..INTO statement which creates a table from a query result.
- Click the tick.
- Once created you will be given a server name. (I’ve hidden mine for security reasons)