Revision #1

There is bug in SQL Azure Reporting Services CTP where reports that take longer than 1 minute to execute are being killed by Windows Azure as "idle connections", see http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/9d43af1a-0100-4f4c-9166-9702776d0d43/

Most of the complex reports take more than a minute to execute. Hence the need arises to be able to deploy the report on an On-Premise SQL Server Reporting Service. However, if try to deploy a SQL Azure Report on an On-Premise SQL Server Reporting Service you will see the error “An attempt has been made to use a data extension 'SQLAZURE' that is either not registered for this report server”

Below are the steps which can be followed to deploy a SQL Azure Report on an On-Premise SQL Server Reporting Service:

Pre-Requisites:

• Create a SQL Azure Report by referring to the samples available here: http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-reporting-samples.aspx

• Configure an On-Premise SQL Server Reporting Service by referring here: http://channel9.msdn.com/Learn/Courses/SQL2008R2TrainingKit/ReportingServices2008/ReportingServicesDemo/Setup-and-Configuration

Add SQL Azure Extension to RSReportServer.config:

• Go to <Install Dir>\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer

• Open RSReportServer.config

• Go to the xml node Configuration/Extensions/Data

• Add a child node <Extension Name="SQLAzure" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

• Save RSReportServer.config

Deploy the Report:

• Browse to the Report Manager URL: http://Server/Reports

• Click Upload File

• Browse to the .rdl file, and then upload it

Note: The credentials to be supplied to the report should have the username in the format username@servername