SSRS doesn't run on localhost
SSRS doesn't run on localhost but it does run on server. I get following error:
The underlying connection was closed: An unexpected error occurred on a receive.
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
An existing connection was forcibly closed by the remote host
.......................when i look at IIS SERVER I GET BELOW ERROR. 2011-08-22 09:50:25 192.168.150.35 GET /ReportManager/Reserved.ReportViewerWebControl.axd OpType=StyleSheet&Version=2005.090.5000.00 8080 NGP_DOMAIN1\nabdhul 192.1.1.194 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+WOW64;+Trident/4.0;+InfoPath.2;+.NET+CLR+3.0.04506.648;+.NET+CLR+3.5.21022;+OfficeLiveConnector.1.4;+OfficeLivePatch.1.3;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729)
200 0 0 10
2011-08-22 09:50:26 192.168.150.35 GET /ReportManager/Reserved.ReportViewerWebControl.axd OpType=Calendar&LCID=2057&selectDate= 8080 - 192.1.1.194 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+WOW64;+Trident/4.0;+InfoPath.2;+.NET+CLR+3.0.04506.648;+.NET+CLR+3.5.21022;+OfficeLiveConnector.1.4;+OfficeLivePatch.1.3;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729)
401 2 5 1
2011-08-22 09:50:26 192.168.150.35 GET /ReportManager/Reserved.ReportViewerWebControl.axd OpType=Calendar&LCID=2057&selectDate= 8080 - 192.1.1.194 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+WOW64;+Trident/4.0;+InfoPath.2;+.NET+CLR+3.0.04506.648;+.NET+CLR+3.5.21022;+OfficeLiveConnector.1.4;+OfficeLivePatch.1.3;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729)
401 2 5 1
2011-08-22 09:50:26 192.168.150.35 GET /ReportManager/Reserved.ReportViewerWebControl.axd OpType=DocMapReport&ClientController=ctl142&ReportUrl=%2fReportManager%2fReserved.ReportViewerWebControl.axd%3fReportSession%3dh3htwgzomhicku45exib4q45%26ControlID%3d7dad9724306444a6938e5c4383359464%26Culture%3d2057%26UICulture%3d9%26ReportStack%3d1%26OpType%3dReportArea%26Controller%3dctl142%26PageNumber%3d1%26ZoomMode%3dPercent%26ZoomPct%3d100%26ReloadDocMap%3dtrue%26SearchStartPage%3d0%26LinkTarget%3d_top
8080 - 192.1.1.194 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+WOW64;+Trident/4.0;+InfoPath.2;+.NET+CLR+3.0.04506.648;+.NET+CLR+3.5.21022;+OfficeLiveConnector.1.4;+OfficeLivePatch.1.3;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729)
401 2 5 1
2011-08-22 09:50:26 192.168.150.35 GET /ReportManager/Reserved.ReportViewerWebControl.axd OpType=DocMapReport&ClientController=ctl142&ReportUrl=%2fReportManager%2fReserved.ReportViewerWebControl.axd%3fReportSession%3dh3htwgzomhicku45exib4q45%26ControlID%3d7dad9724306444a6938e5c4383359464%26Culture%3d2057%26UICulture%3d9%26ReportStack%3d1%26OpType%3dReportArea%26Controller%3dctl142%26PageNumber%3d1%26ZoomMode%3dPercent%26ZoomPct%3d100%26ReloadDocMap%3dtrue%26SearchStartPage%3d0%26LinkTarget%3d_top
8080 NGP_DOMAIN1\nabdhul 192.1.1.194 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+WOW64;+Trident/4.0;+InfoPath.2;+.NET+CLR+3.0.04506.648;+.NET+CLR+3.5.21022;+OfficeLiveConnector.1.4;+OfficeLivePatch.1.3;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729)
200 0 0 57
2011-08-22 09:50:26 192.168.150.35 GET /ReportManager/Reserved.ReportViewerWebControl.axd ReportSession=h3htwgzomhicku45exib4q45&ControlID=7dad9724306444a6938e5c4383359464&Culture=2057&UICulture=9&ReportStack=1&OpType=ReportArea&Controller=ctl142&PageNumber=1&ZoomMode=Percent&ZoomPct=100&ReloadDocMap=true&SearchStartPage=0&LinkTarget=_top
8080 - 192.1.1.194 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+WOW64;+Trident/4.0;+InfoPath.2;+.NET+CLR+3.0.04506.648;+.NET+CLR+3.5.21022;+OfficeLiveConnector.1.4;+OfficeLivePatch.1.3;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729)
401 2 5 0
2011-08-22 09:50:26 192.168.150.35 GET /ReportManager/Reserved.ReportViewerWebControl.axd OpType=Calendar&LCID=2057&selectDate= 8080 NGP_DOMAIN1\nabdhul 192.1.1.194 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+WOW64;+Trident/4.0;+InfoPath.2;+.NET+CLR+3.0.04506.648;+.NET+CLR+3.5.21022;+OfficeLiveConnector.1.4;+OfficeLivePatch.1.3;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729)
200 0 0 146
2011-08-22 09:50:26 ::1 POST /ReportServer/ReportExecution2005.asmx - 8080 - ::1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+WOW64;+Trident/4.0;+InfoPath.2;+.NET+CLR+3.0.04506.648;+.NET+CLR+3.5.21022;+OfficeLiveConnector.1.4;+OfficeLivePatch.1.3;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729)
401 2 5 1
2011-08-22 09:50:26 ::1 POST /ReportServer/ReportExecution2005.asmx - 8080 NGP_DOMAIN1\SQLreports ::1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+WOW64;+Trident/4.0;+InfoPath.2;+.NET+CLR+3.0.04506.648;+.NET+CLR+3.5.21022;+OfficeLiveConnector.1.4;+OfficeLivePatch.1.3;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729)
200 0 0 2
2011-08-22 09:50:26 ::1 POST /ReportServer/ReportExecution2005.asmx - 8080 - ::1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+WOW64;+Trident/4.0;+InfoPath.2;+.NET+CLR+3.0.04506.648;+.NET+CLR+3.5.21022;+OfficeLiveConnector.1.4;+OfficeLivePatch.1.3;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729)
401 2 5 0
2011-08-22 09:50:26 ::1 POST /ReportServer/ReportExecution2005.asmx - 8080 NGP_DOMAIN1\SQLreports ::1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+WOW64;+Trident/4.0;+InfoPath.2;+.NET+CLR+3.0.04506.648;+.NET+CLR+3.5.21022;+OfficeLiveConnector.1.4;+OfficeLivePatch.1.3;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729)
200 0 0 11
2011-08-22 09:50:26 ::1 GET /ReportServer %2fUSA%2fCost+Reports%2fPurchase+Cost+Report+NY&rs:SessionID=h3htwgzomhicku45exib4q45&rs:command=Render&rs:Format=HTML4.0&rc:HTMLFragment=true&rc:Section=1&rc:StreamRoot=%2fReportManager%2fReserved.ReportViewerWebControl.axd%3fReportSession%3dh3htwgzomhicku45exib4q45%26ControlID%3d7dad9724306444a6938e5c4383359464%26Culture%3d2057%26UICulture%3d9%26ReportStack%3d1%26OpType%3dReportImage%26StreamID%3d&rc:ResourceStreamRoot=%2fReportManager%2fReserved.ReportViewerWebControl.axd%3fReportSession%3dh3htwgzomhicku45exib4q45%26ControlID%3d7dad9724306444a6938e5c4383359464%26Culture%3d2057%26UICulture%3d9%26ReportStack%3d1%26OpType%3dReportImage%26ResourceStreamID%3d&rc:ActionScript=ClientReport7dad9724306444a6938e5c4383359464.ActionHandler&rc:StyleStream=true&rc:LinkTarget=_top&rc:UserAgent=Mozilla%2f4.0+(compatible%3b+MSIE+7.0%3b+Windows+NT+5.2%3b+WOW64%3b+Trident%2f4.0%3b+InfoPath.2%3b+.NET+CLR+3.0.04506.648%3b+.NET+CLR+3.5.21022%3b+OfficeLiveConnector.1.4%3b+OfficeLivePatch.1.3%3b+.NET+CLR+2.0.50727%3b+.NET+CLR+3.0.4506.2152%3b+.NET+CLR+3.5.30729)&rc:Toolbar=false&rs:ErrorResponseAsXml=true&rs:AllowNewSessions=false
8080 - ::1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+WOW64;+Trident/4.0;+InfoPath.2;+.NET+CLR+3.0.04506.648;+.NET+CLR+3.5.21022;+OfficeLiveConnector.1.4;+OfficeLivePatch.1.3;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729) 401 2 5
1
2011-08-22 09:50:26 192.168.150.35 GET /ReportManager/Reserved.ReportViewerWebControl.axd ReportSession=h3htwgzomhicku45exib4q45&ControlID=7dad9724306444a6938e5c4383359464&Culture=2057&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl142TouchSession0&CacheSeed=Mon%20Aug%2022%2010%3A50%3A26%202011
8080 - 192.1.1.194 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+WOW64;+Trident/4.0;+InfoPath.2;+.NET+CLR+3.0.04506.648;+.NET+CLR+3.5.21022;+OfficeLiveConnector.1.4;+OfficeLivePatch.1.3;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729)
401 2 5 0
2011-08-22 09:51:35 192.168.150.35 GET /ReportManager/Reserved.ReportViewerWebControl.axd ReportSession=2l1pkqismgb5ul55qvjwpxyx&ControlID=588e2b4c5efd46eaa8387caae667f5d1&Culture=2057&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl142TouchSession0&CacheSeed=Mon%20Aug%2022%2010%3A51%3A25%202011
8080 - 192.168.150.32 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+Trident/4.0;+.NET+CLR+1.1.4322;+.NET+CLR+2
It is IT...
August 22nd, 2011 1:56pm
Hi NisRiz,
Based on my research, this issue may be caused by there are multiple SQL Server instances in the server, please to this similar
thread: The
underlying connection was closed: An unexpected error occurred on a receive.
Thanks,
Sharp
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
August 28th, 2011 5:43am