Home / server / Questions / 21769
Accepted
Mesh
Asked: 2009-06-09 00:47:57 +0800 CST

Sharepoint Reporting Services on Intranet Farm

  • 772

We have a Intranet Farm with two load balanced front end servers and a separate database, Report server is installed on box 1, so enysys data extenstions can access the sharepoint DOM.

IIS-BOX 1 + Report Server

IIS_BOX 2

SQL Server

The problem is RS fails if the user is accessing box 2, through the load balancer. If we remove Box 2 from the LB - then RS works. Put it back and it intermittently fails.

Anybody got any idea if this topology should work and how to resolve the problem?

sharepoint ssrs wss

2 Answers

  1. Best Answer

    We needed to configure the iis server to use Kerberos Authentication

    see this question for more details

    • 1

  2. On Box 2 are you trying to access reports that are local or load them remotely from box 1? If you are accessing them remotely from Box 1 how are you referencing it?

    Also does Reporting Services work on Box 1 when accessed from the load balancer?

    • 0