Intermitent HTTP 401 error message in a SSRS load balancing deployment.

In a SSRS load balancing deployment, you get intermitently HTTP 401 error message when you do any action that requires connection from one node to the other RS node    When you access to Report Manager using the balancer virtual name (http://<virtualname>/Reports) , you can intermittently get HTTP 401 error message when you do any action…


Configure a Report Server on a load balancing deployment

  Although the main steps to configure Reporting Services are on the msdn article below, sometimes you can find additional errors trying to access Report Manager or Report Server URLs a load balancer deployment. You will find in this blog some additional steps that will help you.                  Configure a Report Server on a…


HTTP 401 error when you access to Report Manager in a load balancing deployment.

In a Reporting  Services load balancing deployment, you receive the following error message while you access to Report Manager using the balancer virtual name in the URL: “The request failed with HTTP Status 401” However, the Report Server URL works properly. This is solved by configuring the ReportServerURL setting on the rsreportserver.config file.             On…


Kerberos authentication in Reporting Services

  • Symptom When you run a report of Reporting Services, you get the following error message. An error hasoccurred during report processing. (rsProcessingAborted) Cannot create a connection to data source ‘DataSource’. (rsErrorOpeningConnection) The connectioneither timed out or was lost. Unable to readdata from the transport connection: An existing connection was forcibly closedby the remote…


Welcome

Hello all,   I am Reporting Services support engineer and I would like to welcome everyone to my blog. I am going to write about the most frequent issues I face everyday with my customers and about their solution. I hope these brushstrokes of Reporting Service will help you to solve problems in your environment if you…