401 Unauthorized Error while loading report through reportviewer in .net website hosted on azure

I have .net website hosted on azure. In that, I am trying to load a report using reportviewer control but i am getting the 401 unauthorize error on load within a minute or 2. I check the azure logs to see the full stack trace error but no log present over there. Then i check the reportserver log files and i found the following stack trace

ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeClientDisconnectionException: A client has disconnected from the Report Server Web service application domain ReportServer_MSSQLSERVER_0-1-130692380425542626. No corrective action is required. An error code has been submitted to ASP.NET to release the connection. The error code is 800708CA. ---> System.Runtime.InteropServices.COMException (0x800708CA): This network connection does not exist. (Exception from HRESULT: 0x800708CA)

The records are around 1,50,000 and above. However, sometime it is getting loaded perfectly.

Any help will be appreciated

Thanks,

I believe the reportviewer control relies on session state to maintain details of the report as it's built, and paged. I'm not certain about the details of how azure works but with load balanced servers, I've had to configure a separate Session Server database to allow it to maintain state as it switches from server to server.

Managing session

http://blogs.msdn.com/b/cie/archive/2013/05/17/session-state-management-in-windows-azure-web-roles.aspx

Report viewer and session

http://blogs.msdn.com/b/brianhartman/archive/2009/02/15/did-your-session-really-expire.aspx