Report Formatting: Report Manager not responding

Hi,

I'm hoping to get some help here. I've spend countless hours trying to get Reporting Services running without success.

When I run the Report Manager it does not respond. Coming up with Opening page http://localhost/reports/Pages/Folder.aspx. . . The progress bar ticks along but the page never actually loads. The Configuration tool shows green icons everywhere. No errors in the Event viewer.

I am running Windows XP Professional with SP2. I have uninstalled and re-installed IIS, ASP.NET and SQL2005 numerous times. Varying the order, all without success. What else is involved ?

I have loaded Service Pack 1 and the latest hotfixes. What else can I try ?

Thanks in advance,
Claude

Hi,

are you running IE7 Beta 3 ? Then have a look here: http://www.sqlserver2005.de/sqlserver2005/MyBlog/tabid/56/EntryID/10/Default.aspx

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks Jens. I'm using IE 6.

|||Are you able to browse the report server directly (http://servername/reportserver)?|||

Thanks Brain, gives the same non-response.

|||

Some further clues . . .

When I tried connecting to the Report Server with the Management Studio, the following messages appear:

The underlying connection was closed: An unexpected error occurred on a send. (System.Web.Services)

Authentication failed because the remote party has closed the transport stream. (System)

Any ideas ?

|||

Hi,

there should be a more detailed log in the directory of Reporting Services, perhaps you could try to investigate that and send the relevant portion to the forum, thanks.

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I have a similar problem as Claude. I have two instances of SQL Server (2000 and 2005) installed locally. I am using the Developer version of 2005 running under XP Pro. I dont have administrator rights on my machine.

For some reason I just cannot connect to Report Manager, directly from the browser or from Management Studio. It just hangs and eventually tells you that 'cannot find server'. I tried evrything that Claude has done but no luck.

Any ideas please ?

Thanks

|||Are the services started ? What are the logs telling you ? (event log and log in the log directory)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks Jens.

This is the content of the ReportServerWebApp Logfile:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>New Zealand Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServerWebApp__08_18_2006_18_32_46.log</Path>
<SystemName>ACKCSABATIER01</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
aspnet_wp!ui!1!18/08/2006-18:33:20:: e ERROR: The underlying connection was closed: An unexpected error occurred on a send.
aspnet_wp!ui!1!18/08/2006-18:33:21:: e ERROR: HTTP status code --> 500
-Details--
System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send. > System.IO.IOException: Authentication failed because the remote party has closed the transport stream.

at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)

at System.Net.TlsStream.CallProcessAuthentication(Object state)

at System.Threading.ExecutionContext.runTryCode(Object userData)

at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)

at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)

at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

at System.Net.TlsStream.ProcessAuthentication(LazyAsyncResult result)

at System.Net.TlsStream.Write(Byte[] buffer, Int32 offset, Int32 size)

at System.Net.PooledStream.Write(Byte[] buffer, Int32 offset, Int32 size)

at System.Net.ConnectStream.WriteHeaders(Boolean async)

End of inner exception stack trace

at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)

at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetWebResponse(WebRequest request)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
aspnet_wp!ui!1!18/08/2006-18:33:22:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

|||

Did you get any resolution on this? I can deploy reports from Visual Studio, but I cant manage them. I am having a terrible time trying to get the Server Mangement Studio to connect to Reporting Services. I get the same errors in my logs:System.Net.WebException:

The underlying connection was closed: An unexpected error occurred on a send. > System.IO.IOException: Authentication failed because the remote party has closed the transport stream.