locked
SSRS 2008 NLB: Error accessing Report Manager RRS feed

  • Question

  • I have setup a SSRS 2008 NLB with 2 nodes.  I can access the ReportServer URL (http://<virtual name>/ReportServer_Instance), however when I try to access the Report Manager (http://<virtual name>/Reports_Instance) I received a 401 Unauthorized error.

    Prior to setting up the NLB (and even now if we delete the NLB cluster and revert the SSRS configuration settings) each node worked as expected with the shared report server database.

    Each node is running Windows Server 2008 DataCenter Edition and SQL Server 2008 Enterprise Edition (Reporting Services).  The shared report server database is hosted on a Windows Server 2008 Failover Cluster w/ SQL Server 2008 Enterprise Edition.

    I have read the BOL articles a number of times and cannot find what step might have been missed.

    Each SSRS node has been setup to support scale-out deployment and is capable of accessing the test report which we uploaded.
    The NLB is setup and appears to function properly.
    The RSReportServer.Config file was updated with the appropriate settings:  Hostname, UrlRoot

    With IE's integrated security feature checked, when the ReportManager is accessed using the virtual name, the user is presented a log in dialog box.  No matter what credentials we try, they appear to fail.  We have tried both local users (inc. Administrator) and domain users (inc. Domain\Administrator).  With IE integrated security unchecked, the page simply displays an unauthorized message.

    I have read that SSRS 2008 can run in an NLB cluster, however it seems difficult to configure.  Any ideas?

    Thanks,

    David

    Thursday, February 19, 2009 3:15 PM

Answers

All replies

    • Marked as answer by buckindb Thursday, February 19, 2009 8:08 PM
    Thursday, February 19, 2009 5:33 PM
  • I think report manager failed to talk to report server. So you should see the normal report manager with images and title, but with HTTP 401 message at the place where the list of folders was supposed to be displayed. Is that correct?
    Can you try specifying http://<virtual name>/ReportServer_Instance for <ReportServerUrl> in rsreportserver.config?

    Thursday, February 19, 2009 6:39 PM
  • @Neeraja:  Thanks for the link!  This solved my problem.  I made the necessary registry addtion to each node in the NLB cluster and now the SSRS NLB works.

    @James:  Yes, what you described is what I observed.  What looked like the Report Manager would load, however it should display a 401 unauthorized message.  I did indeed have the <ReportServerUrl> parameter set.  (It looks like I failed to list it in the OP).
    Thursday, February 19, 2009 8:11 PM