SSRS and Azure SQL reports - cost and implementation

Question

I have currently implemented several reports for a demo project using Azure Reports and Report Builder. Now we are going to design reports correctly. I have a few questions about SSRS.

• We need a subscription and schedule, so I guess we need to set up an SSRS server, can this be hosted on Azure or where is this a good place? We do not have our own servers.
• What is the cost of licensing?
• Our application is an MVC 4 application, and I believe that this can cause problems with the placement of the report viewer (without feedback). What would be the best approach to integrated reporting experience?

thanks

Answer 1

Keep in mind that Microsoft's recommendation to install ssrs on one Azure VM using the SQL Enterprise gallery image will cost you more than $ 1,600 per month and does not meet the requirement of two copies for Microsoft SLA and does not provide high availability (HA). We are very upset by Microsoft right now about this.

Answer 2

SQL Reporting will end service on October 31, 2014.

Answer 3

Old question, but I just rolled over, so here are some quick answers:

Windows Azure SQL Reporting (also called SQL Azure Reporting Services) ends October 31/2014.

Instead, Microsoft recommends a (apparently much less confusing) option to install SSRS on an Azure VM. https://azure.microsoft.com/en-us/documentation/articles/virtual-machines-provision-sql-server/

So, to answer (1) yes, you can run SSRS on Azure VM

(2) - licensing - Azure allows you to directly pay for virtual machines that include SSRS. For example, you can get SQL Server Standard 2012 (including SSRS) on "Small" Server 2012 vm for about £ 64 per month - see the prices here http://www.windowsazure.com/en-us/pricing/details/virtual- machines / # sql-server

Just select "new virtual machine" and then "select from gallery" and select an image with SQL Server or Enterprise standard.

(3) Report Viewer component - you are right that the ReportViewer component works as a classic ASP.NET, and not as an MVC element. However, you can mix classic ASP.NET pages with MVC views / controllers in the same project if you are careful. See This Related Question: Will MSFT Report Viewer (rdlc) work with MVC .

Answer 4

EDIT 2015-07-21: Windows Azure SQL Reporting was discontinued by Microsoft on October 31, 2014 - the original answer contained links to Azure SQL Reporting documentation, which no longer works and was deleted

• Subscriptions and scheduling are not supported by Azure SQL Reporting, so you will need to install SSRS somewhere. A virtual or local virtual machine depends on many factors, such as your budget, internal infrastructure infrastructure, the overall cloud strategy of your organization.

• Need to be more specific - the cost of licensing? Azure SQL Reporting? Virtual machines? SQL Server Licensing?

• In this article, you should start by integrating applications for SSRS: Integrating Reporting Services into Applications

Answer 5

The costs must have risen since it is now £ 183 for SQL Standard and ~ £ 8 for Windows Server A0, so I believe Reporting Services in Azure is using it ~ 191 pounds a month, which is much more than the summer Azure reporting. You can try to use an image of the web version of SQL Server, but it will not connect to data sources other than the web edition of SQL Server.