Deploy Windows Azure SQL Reporting on an On-Premise SQL Server Reporting Service

Deploy Windows Azure SQL Reporting on an On-Premise SQL Server Reporting Service

There is bug in Windows Azure SQL 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 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

Leave a Comment
  • Please add 5 and 6 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Ed Price - MSFT edited Original. Comment: Great article! Minor edits.

Page 1 of 1 (1 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Ed Price - MSFT edited Original. Comment: Great article! Minor edits.

Page 1 of 1 (1 items)