Database Application Development - Cloud Database Development and Management - page 313

folders that contain the data sources and reports. With the SQL Reporting Management portal,
the application developer can perform the following tasks:

◾ Create a subscription for the reporting service.

◾ Create an SQL Reporting server to host reports.

◾ After the report server is created, create users on the server and assign these users with dif-

ferent permission levels.

◾ Upload reports to the report server so that the reports can be accessed by front-end users.

◾ Run, update, and download reports.

◾ Create folders for report organization.

◾ Create and edit data sources for the reports.

◾ Monitor the usage of the reports.

In the next chapter, we will accomplish some of the tasks with the SQL Reporting Management
portal after the Windows Azure computing environment is introduced.

ACTIVITY 9.1 DEVELOPING WEB FORM

In this activity, we will irst create the Class Schedule Management form for managing the
class schedule. To make the form a web form so that front-end users can access it through a
web browser, we will create the form with ASP.NET, which is provided by Microsoft Visual
Studio. he following steps will achieve our goals:

TASK 1: CREATE ASP.NET WEB FORM

1. Assume that Microsoft Visual Studio is installed on the virtual machine created in
Chapter 1. To log on to the virtual machine, you need to log on to the Windows
Azure Management Portal through your web browser. After you have logged in, click
V IRTUAL MACHINES . Select the server myserver , which is created in Chapter 1
and click CONNECT . hen, log on to the virtual machine with your user name and
password.

2. After you have logged in, press the Windows Icon key and right click the icon Visual
Studio 2012 on the tile. Click Run as administrator .

3. To create a new project, click the New Project link. In the Recent Templates pane
on the left-hand side of the screen, click Web and select ASP.NET Web Forms
Application in the template pane. Rename the project as MyWebForm (Figure 9.6).
hen, click OK to create the project.

4. Click SQL Server Object Explorer on the left-hand side of the screen. In the SQL
Server Object Explorer, click the Add Server icon. On the Connect to Server dialog,
enter the information about the server name, authentication, login, and password as
shown in Figure 9.7. hen, click Connect . Note that your server name should be dif-
ferent from the server name qmcooqcanr listed in Figure 9.7.

5. he next task is to create a web page, which will be used to manage the data. To do
so, in the Solution Explorer, right click on the MyWebForm node and select Add