Sharing of thoughts and information is what blogging is all about. This way we can learn from each other. Post A Comment!These postings are provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use.
Anthony Bartolo Twitter | LinkedIn
Pierre Roman Twitter | LinkedIn
If you’ve started reading from this post, you’ll need to go through the previous parts of this series before starting this one: Introduction Part 1: Provisioning and Configuring SQL Azure Part 2: Provisioning a Storage Account
With the database and storage account created, the application has to be configured to use them.
Though developers are used to placing configuration parameters in the web.config or app.config, with Cloud applications, these two files are not easily accessible. They’re wrapped into the service package that is encrypted when it’s created. For configuration parameters, such as database connection strings and storage account details, it’s best to place these in the Service Configuration file. This way, the parameters can be changed at any time and will not require the service package to be recompiled and re-uploaded.
Technically you can provide the database and storage account information to the developers who can go into the service configuration file, make the changes, and then send it to you. However, in order to maintain separation of concerns (required by some regulatory bodies) and to maintain the security of the information, it is best not to share the configuration information unless absolutely necessary. The service configuration file is an XML file that can simply be edited using Notepad or your favourite XML editor. For this walkthrough, we’ll use Notepad.
Let’s get started.
Open the Service Configuration File
Retrieve and Setting the Storage Account Information
If the properties pane is not visible, it may be closed. Click the arrow at the top of the closed properties pane to open it.
The application is now configured to use the storage services account securely.
Retrieving and Setting the Database Connection Information
The application is now configured to use the SQL Azure database.
Let’s go back to our to do list and see what we have to do next.