Scale-Out Deployment for SQL Reporting Service (SSRS)

In this article, I will elaborate How to Scale Out SQL Reporting Service (SSRS) to work with two Database Server (Always-on)?

Scenario:

I have a 2-Tire SharePoint 2013 Farm

  • 2 WFE+ APP Servers.
  • 2 Database Servers (Always-on).

SharePoint Farm 2 tire

If  you need to use Reporting Services with SharePoint. it’s recommanded to configure SSRS SharePoint integrated mode with  Reporting service application service on an indpenedent reporting server to ensure the Performance, Manageability and Security.

But in my case, the customer budget is not enough to apply the best practice, Meanwhile configuring SSRS SharePoint integrated mode with  Reporting service application service on the same WFE + APP server lead to low performance.

So I have decided to work with SSRS Native mode to ensure at least the performance and show reports inside SharePoint via:

And in this case, I should configure SSRS Native mode on both SharePoint WFE Servers because as we know the Database Servers are not accessible over the internet,

Note: If you configured SSRS native mode on only one WFE server. you will get it worked properly. but sometimes when browsing the Report Manager URL you will get 404 error!

404 - file or directory not found

Continue reading “Scale-Out Deployment for SQL Reporting Service (SSRS)”

Advertisements

Install and Configure SQL Server Reporting Service (SSRS)

SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).

sql-reporting1.pngIn this article, I will elaborate How to install and configure SQL Server Reporting Service (SSRS) native mode.

Note: The mentioned steps is valid for SSRS 2008 / 2012 / 2014.

Steps: Continue reading “Install and Configure SQL Server Reporting Service (SSRS)”

SSRS Error – The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database

When I tried to deploy SSRS reports ,I got the following error:

The report server cannot decrypt the symmetric key used to access sensitive
 or encrypted data in a report server database

thereportservercannotdecrypt

Cause : Continue reading “SSRS Error – The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database”

SSRS Error – Maximum request length exceeded

I am working on SSRS with SQL Server 2008  R2, when I tried to upload a report with size higher than 4 Mb to Report Manager Folder,I got the following error
Maximumrequestlenghtexceeded
Cause: Continue reading “SSRS Error – Maximum request length exceeded”

s.ArgumentNullException : Value cannot be null. During running a SSRS report within a Report Viewer via Internet Explorer in SharePoint

During running a SSRS report within a Report Viewer webpart that hosted in SharePoint page via Internet Explorer, I got the following error :

s.ArgumentNullException: Value cannot be null.

javascriptdiverror

Cause: Continue reading “s.ArgumentNullException : Value cannot be null. During running a SSRS report within a Report Viewer via Internet Explorer in SharePoint”

Reporting Service render issue within Report Viewer Webpart in SharePoint Server 2013 with IE 10 or later

Using Internet Explorer 10 or later, I tried to browse a SharePoint page holds a Report Viewer Webpart to show a SSRS native mode report. but unfortunately, it shows with unexpected behavior as shown below :nativereportpreviewIE10

Cause: 
Continue reading “Reporting Service render issue within Report Viewer Webpart in SharePoint Server 2013 with IE 10 or later”