SQL Azure Reporting Server – Windows Azure platform

Using SQL Azure Reporting, you can deploy a reporting solution to the Windows Azure platform environment. This solution will not only use data from the cloud SQL Azure database, you will also be deploying the actual Azure report up to the cloud environment.  This will make the Cloud database report accessible to all to the end users who can access the data via the internet.

In order to create the SQL Azure report, we need to do the following three things:

  1. Create a new SQL Azure reporting server in Windows Azure platform
  2. Build a report using SQL Server business intelligence studio development studio (BIDS)
  3. Deploy the SQL Azure report to the cloud environment

Today we are going to simply look at the first step,

Create a new SQL Azure Reporting server in Windows Azure platform

We are assuming you already have a Windows Azure account and that you have already setup a SQL Azure cloud database. If you have not, please read this blog post on the topic.

http://sqlazuretutorials.com/wordpress/installing-windowssql-azure-platform-microsoft-online-services/

We login to our Windows Azure account at this site:

http://windows.azure.com

Next we are going to create a SQL Azure Reporting server. This will be used to render reports from our SQL Azure cloud database to the Windows Azure platform. From the left menu, click on Reporting tab and then select Create a new SQL Azure Report Server from the right side.

This is shown right below.

windows-azure-platform

Next you will get the SQL Azure Reporting server agreement. Go ahead and click “I agree …” and then click Next. This is shown in the screen shot right below.

what-is-windows-azure

In the next section, you can select the SQL Azure Subscription that you would like to use for the cloud database report. Select the Region for the SQL Azure Reporting Server should use. Ideally this location should be the same as the one you selected when you set up your original SQL Azure Server.

Since we are in Dallas TX, we have listed ours as South Central US. This is shown right below.

sql-azure-reporting-server

In the next step, we are going to setup the administrator account for SQL Azure Reporting Server. You will need to have a username and password for this account.  We enter our account information in the next dialog box. Click Finish after this.

sql-azure-report-server

Next it will go ahead and create the reporting server.  In our case the Azure SQL Report Server has the web service URL are listed below.

https://4z2w-e8fke.reporting.windows.net/ReportServer

After we create the SQL Azure reporting server, we can look at some of the options available to us. When you are logged in your Windows Azure platform account and select the Reporting tab on the left, you will see these options on the Report server taskbar:

Server: Create and delete Report server
Manage User:  You can create and delete report users
Data Source: Ability to manage multiple SQL Azure data sources
Folder and Permissions: This can help you organize the reports and control access to them

After we created the SQL Azure report server, we see the following options for Reporting Services tab.

sql-azure-reporting-portal

Finally lets go ahead and log into the SQL Azure Report Server. Go ahead and type the Web service URL for the reporting server that was provided to you. Enter the username and password to login. Here is what we see on our end.

sql-azure-reporting-preview

Once you login you should see something like this as follows. Notice we do not have any report folders or actual reports create just yet. We will do that in another blog post.

sql-server-reporting-services

Related links to SQL Azure Reporting Services:

This entry was posted in Reporting, SQL Azure tutorials, Windows Azure Platform and tagged , , . Bookmark the permalink.

Comments are closed.