Category Archives: AZURE

Windows Azure for Developers Task 3: Understanding Windows Azure Application

An application designed and developed to be as hosted service for windows azure consist of 1. Managed Code 2. XML file for configuration Managed codes are mapped into different Roles XML files are mapped into different configuration settings. If we see the below diagram it explains all the components mainly involved in Windows Azure application.ContinueContinue reading “Windows Azure for Developers Task 3: Understanding Windows Azure Application”

Windows Azure for Developers task 2: Adding Cloud Service project to existing ASP.Net Web Application

Adding Cloud Service project to existing ASP.Net Web Application Imagine we are moving existing Web Application or ASP.Net MVC Web Application to cloud. In that case we need to add cloud service to existing Web Application or ASP.Net MVC Web Application. We have a solution for Web Application is as below, Now right click onContinueContinue reading “Windows Azure for Developers task 2: Adding Cloud Service project to existing ASP.Net Web Application”

Windows Azure for Developers Task 1: Resolving Failed to initialize Windows Azure storage emulator Error

I thought to start learning Windows Azure. I installed Azure SDK and created a project by choosing Windows Azure project template from cloud tab and creating a Web Role. I just put a label on aspx file and when tried running the project I got the below error When I switched to Output Window, IContinueContinue reading “Windows Azure for Developers Task 1: Resolving Failed to initialize Windows Azure storage emulator Error”

Migrating Data Base from SQL Server 2008 R2 Enterprise to SQL Azure

In this walkthrough we will migrate an existing Database from SQL Server 2008 R2 to SQL Azure. Creating Database The first step is to create database. We are going to use School database. Script of sample School Database copy from here Generate Database Script for SQL Azure Right click on School Database and select Tasks.ContinueContinue reading “Migrating Data Base from SQL Server 2008 R2 Enterprise to SQL Azure”

Connecting from SQL Server 2008 management studio to SQL Azure

In this walkthrough we will see how to connect from Local SQL server management studio to SQL Azure. Follow the below steps. Open SQL Server management studio You will get Connect to server dialog box. Click cancel on that. After cancelling the dialog box click on New Query from left top On clicking New Query,ContinueContinue reading “Connecting from SQL Server 2008 management studio to SQL Azure”

Creating Firewall rule for SQL Azure

All access to SQL azure is blocked by firewall. By default Database created on SQL Azure is blocked by firewall for the security reason.. Any try to external access or access from any azure application is blocked by firewall.                                                                                          Image taken from MSDN Connecting from Local system When we want to connect SQL AzureContinueContinue reading “Creating Firewall rule for SQL Azure”

Walkthrough on creating a Database in SQL Azure

In this article, we will see how to create database in SQL Azure. Step1 Login SQL Azure portal with your live credential https://sql.azure.com/ Step 2 Click on SQL Azure tab. You will get the project , you have created for yourself. Step3 Click on the project. In my case project name is debugmode. After clickingContinueContinue reading “Walkthrough on creating a Database in SQL Azure”

Setting up the Firewall on local system/computer to connect to SQL Azure

If we want to connect to SQL Azure from local system then we need to create an exception at local firewall for TCP port 1433. Follow the below steps to create Exception on Windows 7 machine Step 1 Click on Start button and then in Search text box type Firewall. Step 2 You will ableContinueContinue reading “Setting up the Firewall on local system/computer to connect to SQL Azure”