SQL Reporting Sunset FAQ
Updated: October 31, 2014
SQL Reporting was discontinued on October 31 2014, twelve months after the initial shutdown announcement.
While most customers have transitioned from SQL Reporting to SQL Server Reporting Services (SSRS) running on Azure Virtual Machines (VM), a few still have reports in SQL Reporting. Although the report servers are no longer online, you can retrieve report definition (.rdl) and shared data sources (.rsds) from Microsoft until April 30, 2015. On that date, any unclaimed data will be deleted.
We recommend running SSRS reports on Azure VMs. There are multiple advantages to this approach. Namely, the benefits of a hosted environment in Azure, but with all of the features of SSRS. SSRS has the report design, programmability, and report distribution features most requested by users.
SQL Server Reporting Services (SSRS) running on Azure Virtual Machines provides the full native mode feature set including: scheduled reporting, data driven subscriptions, email subscriptions, code segments and custom extensions, domain joining capability, and windows authentication integration. Additional benefits include superior data resiliency and the ability to suspend virtual machines when not in use, so you pay only for the hours that you use. For more information about the features and capabilities of reporting with Azure Virtual Machines configured with SSRS, please visit Benefits of SSRS on Azure VMs.
For resources and documentation on how to create an Azure Virtual Machine with SQL Server Reporting Services (SSRS) please visit Create a Report Server on a Virtual Machine using PowerShell.