none
Report services access problem under load balancer web farm in ASP.NET web forms

    Question

  • Web App:

    I have an ASP.NET web forms web app, which uses report viewer control.

    The app is hosted in two web instances, and is using F5 load balancer.

    The app is using InProc session state.

    Report Viewer Control

    The report viewer (ver 10) is using remote processing mode.

    Reporting services connection is specified via IReportServerConnection

    Access to reporting services is via Active directory user name and passwords.

    Reporting server

    SQL Server 2008 r2/Reporting services

    Settings on two web instances

     

    <appSettings>

    <add key="ReportViewerServerConnection" value="MyNamespace.MyClass, MyAssembly"/> 

    </appSettings> 

    <system.web>   

    <sessionState mode="InProc" timeout="25"  /> 

    </system.web>

    other settings omitted (Machine key is the same on both instances)


    The app was working since beginning, but it has a problem recently. The problem is that the report viewer uses machine account from each web instance for its request, rather than the active direction user name/password mentioned at the beginning. Thus, the reporting service rejects the requests.

    The exception found on web instance is below:

    The report execution SessionIDXXXXX has expired or cannot be found. (rsExecutionNotFound).

    The exceptions found on reporting server is below:

    Error in getting session data: Session SessionIDXXXXX does not belong to WebInstance1\AccountName$
    INFO: LoadSnapshot: Item with session: SessionIDXXXXX, reportPath: , userName: WebInstance1\AccountName$ not found in the database
    ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: The report execution SessionIDXXXXX has expired or cannot be found.;
    ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database.;

    I would appreciate for any advice.

    Friday, July 4, 2014 9:26 PM

All replies

  • Web App:

    I have an ASP.NET web forms web app, which uses report viewer control.

    The app is hosted in two web instances, and is using F5 load balancer.

    The app is using InProc session state.

    Report Viewer Control

    The report viewer (ver 10) is using remote processing mode.

    Reporting services connection is specified via IReportServerConnection

    Access to reporting services is via Active directory user name and passwords.

    Reporting server

    SQL Server 2008 r2/Reporting services

    Settings on two web instances

     

    <appSettings>

    <add key="ReportViewerServerConnection" value="MyNamespace.MyClass, MyAssembly"/> 

    </appSettings> 

    <system.web>    <sessionState mode="InProc" timeout="25"  /> 

    </system.web>

    other settings omitted (Machine key is the same on both instances)

    The app was working since beginning, but it has a problem recently. The problem is that the report viewer uses machine account from each web instance for its request, rather than the active direction user name/password mentioned at the beginning. Thus, the reporting service rejects the requests.

    The exception found on web instance is below:

    The report execution SessionIDXXXXX has expired or cannot be found. (rsExecutionNotFound).

    The exceptions found on reporting server is below:

    Error in getting session data: Session SessionIDXXXXX does not belong to WebInstance1\AccountName$
    INFO: LoadSnapshot: Item with session: SessionIDXXXXX, reportPath: , userName: WebInstance1\AccountName$ not found in the database
    ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: The report execution SessionIDXXXXX has expired or cannot be found.;
    ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database.;

    I would appreciate for any advice.



    Friday, July 4, 2014 9:24 PM
  • Hi,

    I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.

    Thank you for your understanding and support.

    Regards,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Monday, July 7, 2014 8:40 AM
    Moderator
  • Hi,

    To further understand your issue, could you please check your IIS authentication setting in your IIS manager and web.config? Which kind of authentication do you use ?

    IIS Authentication:

    http://msdn.microsoft.com/en-us/library/aa292114(v=vs.71).aspx

    Best Regards



    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Wednesday, July 9, 2014 2:29 AM
  • Hi,

    Thanks. As requested, the IIS Authentication are Anonymous and Forms Authentication. The rest is disabled.

    Please let me know if you require further information.

    Wednesday, July 9, 2014 8:59 AM
  • Hi,

    By default, IIS enables anonymous authentication and uses the IUSR_machinename user account with the password controlled by IIS.

    Please try to disable anonymous authentication in IIS and check whether it works.

    Also the following articles may interest you:

    IIS Authentication

    http://msdn.microsoft.com/en-us/library/aa292114(v=vs.71).aspx

    Configuring Authentication in IIS 7

    http://technet.microsoft.com/en-us/library/cc733010(v=WS.10).aspx

    Impersonate in Reporting Services ASP.NET Web Clients

    http://blogs.msdn.com/b/bryanke/archive/2004/03/03/83345.aspx

    Authentication, Role-based Security, and SQL Reporting Services Web Services

    http://odetocode.com/Articles/216.aspx

    Best Regards


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Friday, July 11, 2014 1:52 AM
  • Grappling with this issue now too, as existing, WORKING web application is moving to web farm.

    Says here http://msdn.microsoft.com/en-us/library/ms251661(v=vs.100).aspx:

    <sessionState>

    ...

    InProc is the default setting and you can use it if your application runs on one computer. Do not use this setting if your reports run in an application that runs in a Web farm.


    Monday, July 28, 2014 9:18 PM