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.

1. Changes on the rsreportserver.config file (This file is located by default at the local report server path: C:\Program Files\Microsoft SQL Server\MSRSx.InstanceName\Reporting Services\ReportServer).

*If you have Sharepoint Integration mode in SSRS please add here the URL for the Sharepoint Site.

3. Add the following tag:

<Hostname>balancervirtualname.domain</Hostname>

In the following location: <Service>

<Hostname>virtual_server.domain</Hostname>

<IsSchedulingService>True</IsSchedulingService>

<IsNotificationService>True</IsNotificationService> […]

2. Open the web.config file on each Report Manager (located at: C:\Program Files\Microsoft SQL Server\MSRSx.InstanceName\Reporting Services\ReportManager). You will see a section <system.web> and inside this section a tag called <machineKey>

1. We need to have the same machinekey on both SSRS servers (that means on the web.config files of Report Manager on each server).