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

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:


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