There is a bug in Windows Azure SQL Reporting Services CTP where reports that take longer than one 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 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 Report on an On-Premise SQL Server Reporting Service:

Pre-Requisites:

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:µ

  • 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