Unable to access Report Manager

Running RS 2000 version 8.00.1038.00 on a Windows 2003 server with SP1 applied.

Yesterday I was receiving HTTP 401.1 errors. I appled workaround method 1 from article ID 896861 and now I am receiving the following message when I try and access/reports">https://<websitename>/reports.

The request failed with HTTP status 404: Not Found.
Anyone have any ideas how to fix this?

Thanks

Eric

[448 byte] By [eric.adams] at [2008-1-27]
# 1

Here is a log event from the ReportServerWebApp log for the latest attempt to access the Report Manager.

w3wp!ui!1778!6/1/2005-12:04:57:: e ERROR: The request failed with HTTP status 404: Not Found.
w3wp!ui!1778!6/1/2005-12:04:57:: e ERROR: HTTP status code --> 500
-Details--
System.Net.WebException: The request failed with HTTP status 404: Not Found.

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

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

at Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String Item)

at Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String Item)

at Microsoft.ReportingServices.UI.Permissions.GetPermissions()

at Microsoft.ReportingServices.UI.Permissions..ctor(String path)

at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)

at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser()

at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs e)

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

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

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

at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!1778!6/1/2005-12:04:57:: 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)

eric.adams at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 2
See http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=15365

HTTP Error 404.1 thread, maybe that will help you.

turnkey at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 3

I have been spending about 2 months trying to get this up and running on W2k3 with SP1. No luck. I am getting the 401 error also.

I implemented the fixed posted per the knowledge article but still no luck. I am ready to give up on this product as it has been nothing but a struggle. I know it is a great product but man, this is extreme.

Does anyone have any more recommendations?

Praying,

Mitch

MitchMyers at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 4

Hey mitch,,

Im running into the same problem.. Did you ever find a solution?

sl0140 at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 5

Report manager makes SOAP calls to the RS web service. The URL it uses is dictated by the content of RsWebApplication.config. See this help link for details on the URLs in there http://msdn2.microsoft.com/en-us/library/ms155878(SQL.90).aspx

I would look at whether ReportServerUrl or ReportServerVirtualDirectory are pointing to virtual directories that do not exist in IIS.

Hope that helps

Tudor

TudorTrufinescu-MSFT at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 6

Thanks Tudor..

Have checked out the RsWebApplication.config and all looks ok.. the exact error messages i am getting in the log is about reportservice2005.asmx doesn not exist.. i have pasted the log file below?

-

w3wp!ui!1!4/05/2006-11:33:32:: e ERROR: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
w3wp!ui!1!4/05/2006-11:33:32:: e ERROR: HTTP status code --> 500
-Details--
Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. > System.Net.WebException: The request failed with HTTP status 404: Not Found.

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()

End of inner exception stack trace

at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)

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)
w3wp!ui!5!4/05/2006-11:33:32:: Unhandled exception: System.Web.HttpException: The file '/gaplreports/ReportService2005.asmx' does not exist.
at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath)
at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile)
at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile)
at System.Web.Compilation.BuildManager.GetVPathBuildResult(HttpContext context, VirtualPath virtualPath)
at System.Web.UI.WebServiceParser.GetCompiledType(String inputFile, HttpContext context)
at System.Web.Services.Protocols.WebServiceHandlerFactory.GetHandler(HttpContext context, String verb, String url, String filePath)
at System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig)
at System.Web.HttpApplication.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
w3wp!ui!1!4/05/2006-11:33:33:: 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)

If anyone can help.. that would be great!!!

thanks

scotty

sl0140 at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 7

Have you set the permissions in IIS?

I had the same issue and resolved it by setting all the permissions to 'Allow'

Hope this helps,

Katy.

KatyB at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 8

Hey Katy,

I have now fixed this. What it was, was the RSwebapplication.config was setup incorrectly.

as i had report server installed aloing side sharepoint 2003, I had configured the report server to use different virtual directory names and when i made the changes to the config file, i had it the incorrect way around, hence why i go t the message saying it couldnt find a file.

The correct file is::

<ReportServerUrl>http://reports.ap.corp/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

I had the file configured as reports instead of report server...

Hope this may help anyone else who has the same problems.

THanks for all the help guys

scotty

sl0140 at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...

SQL Server

Site Classified