You are currently reviewing an older revision of this page.
Go to current version

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:


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 upload it

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

Revert to this revision