Introduction

The SQLReportingAdmin sample for Windows Azure SQL Reporting demonstrates the usage of SQL Reporting APIs, and manages (add/update/delete) permissions of SQL Reporting users.

In the current implementation, the login credentials are stored in the configuration. It is recommended to use a mechanism to encrypt and protect the user credentials while trying to access the Windows Azure SQL Reporting portal.

Prerequisites

You must install the Windows Azure Software Development Kit (SDK) 1.3 or later to run the SQLReportingAdmin sample. You can get the latest version at Windows Azure SDK Downloads.

Building the Sample

1. Use administrator privileges to launch either Microsoft Visual Studio 2010 or
   Microsoft Visual Web Developer Express 2010. To do this, in Start | All Programs | Microsoft Visual Studio 2010, right-click the Microsoft Visual Studio 2010 (or Microsoft Visual Web Developer Express 2010) and choose Run as Administrator. If the User Account Control dialog appears, click Continue. The Windows Azure compute emulator requires that Visual Studio be launched with administrator privileges. For more information about Windows Azure Compute Emulator and other SDK tools, see Overview of the Windows Azure SDK Tools.
2. In Visual Studio, on the File menu, click Open, and then browse to folder
   where you extracted the samples, then browse to the SQLReportingAdminSample folder.
3. Open SQLReportingAdminSample.sln file.
4. In Solution Explorer, under ManagerPermission project, open Web.Config. If Solution Explorer is not already visible, click Solution Explorer on the View menu.
5. Update the appSettings section with the below code:
6. C#

   Edit|Remove

   csharp

   <appSettings>
       <add key="RSSERVER_NAME" value="******"/>
       <add key="RSUSERNAME" value="******"/>
       <add key="RSPASSWORD" value="*****"/>    
   </appSettings>
   

   <appSettings> 
       <add key="RSSERVER_NAME" value="******"/> 
       <add key="RSUSERNAME" value="******"/> 
       <add key="RSPASSWORD" value="*****"/>     
   </appSettings> 
   

   In the above example, consider replacing the values for RSSERVER_NAME, RSUSERNAME, and RSPASSWORD with appropriate values from your SQL Reporting
   report server.
7. Press F6 to build the application from Visual Studio. Press F5 to debug the application. When you debug or run the application from Visual Studio, the following actions are performed:
   1. The application is packaged.
   2. The Windows Azure Compute Emulator is started.
   3. The application package is deployed to the Compute Emulator
   4. The browser displays the default web page defined by the web role.

Description

Before you install and use Windows Azure SQLReportingAdmin sample you must:

• Review the license terms by clicking on Custom link above.
• Print and retain a copy of the license terms for your records.

By downloading and using the SQLReportingAdmin sample, you agree to such license terms. If you do not accept them, do not use the software.

1. Once you launch the application, you will see all the report items listed along with the path of the report item, and the type of report item.
2. 
3. Select the report item for which you want to modify permissions. You can modify permissions of any report item by clicking on Permissions button.
4. 
5. The Manage Permissions dialog is launched.
6. Click Edit button corresponding to the user for whom you want to edit permissions.
7. Select/Unselect the checkboxes for the corresponding roles that are displayed. Click Update button to update the permissions.
8. 
9. Click Save button to update the permissions.

More Information

• Windows Azure SQL Reporting
• Getting started with Windows Azure SQL Reporting
• Windows Azure SQL Reporting for Application developers
• Guidelines and Limitations for Windows Azure SQL Reporting