Error when open Report Manager

RS is installed on the same server with the WebServer. I run this from a
domain network PC:
http://WebServerName/Reports/Pages/Folder.aspx
and I receive this error:
The request failed with HTTP status 401: Unauthorized.
What I checked:
1.On the WebServer go in IIS , then Default Web Site, then Reports, then
Proprieties, then Security and ONLY Integrated Windows Authentication is
checked
2. The save as above for ReportService under Default Web Site
3. Open Windows Explorer on the Web Server and go to C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer where
ReportService.asmx file is located. In the same folder have a look in
web.config file and:
<authentication mode="Windows" />
<identity impersonate="false" />
4 IIS is version 6
5. Web Server is Windows 2003
6. Went in Logs for RS and this is what I found:
w3wp!ui!1860!17/02/2006-13:20:44:: e ERROR: The request failed with HTTP
status 401: Unauthorized.
w3wp!ui!1acc!17/02/2006-13:20:44:: e ERROR: The request failed with HTTP
status 401: Unauthorized.
w3wp!ui!1acc!17/02/2006-13:20:45:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The request failed with HTTP status 401:
Unauthorized.
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.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
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.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!1860!17/02/2006-13:20:45:: e ERROR: HTTP status code --> 500
--Details--
7. Changed in IIS to use Anonymous access and then Report Manager opens
without error but there is no report there (only Home directory and that's
all).After working on this problem for a week, I found posting from Jonny W.
and it worked for me.
If anyone else is having the same problem this KB article applies:
http://support.microsoft.com/default.aspx/kb/896861/en-us
Eddy wrote:
> RS is installed on the same server with the WebServer. I run this from a
> domain network PC:
> http://WebServerName/Reports/Pages/Folder.aspx
> and I receive this error:
> The request failed with HTTP status 401: Unauthorized.
> What I checked:
> 1.On the WebServer go in IIS , then Default Web Site, then Reports, then
> Proprieties, then Security and ONLY Integrated Windows Authentication is
> checked
> 2. The save as above for ReportService under Default Web Site
> 3. Open Windows Explorer on the Web Server and go to C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer where
> ReportService.asmx file is located. In the same folder have a look in
> web.config file and:
> <authentication mode="Windows" />
> <identity impersonate="false" />
> 4 IIS is version 6
> 5. Web Server is Windows 2003
> 6. Went in Logs for RS and this is what I found:
> w3wp!ui!1860!17/02/2006-13:20:44:: e ERROR: The request failed with HTTP
> status 401: Unauthorized.
> w3wp!ui!1acc!17/02/2006-13:20:44:: e ERROR: The request failed with HTTP
> status 401: Unauthorized.
> w3wp!ui!1acc!17/02/2006-13:20:45:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The request failed with HTTP status 401:
> Unauthorized.
> 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.ListSecureMethods()
> at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> methodname)
> at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> 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.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain()
> w3wp!ui!1860!17/02/2006-13:20:45:: e ERROR: HTTP status code --> 500
> --Details--
> 7. Changed in IIS to use Anonymous access and then Report Manager opens
> without error but there is no report there (only Home directory and that's
> all).

Error when moving a report server database to another server

We have a new server (SRV63) and I followed the instructions at http://msdn2.microsoft.com/en-us/library/ms156421.aspx to move the report server database from our old server (SRV38). Everything appeared OK, however, when I went to initialize the instance in the Reporting Services Configuration tool, it shows an initialized instance (checkbox is checked) for SRV38 and and uninitialized instance for SRV63 (checkbox is not checked). Please note that I am not trying to create a scale-out deployment. I tried to initialize SRV63 but received the error below.

--

ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server installation is not initialized. (rsReportServerNotActivated)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)

This is the only thing stopping me from shutting down SRV38 and bringing SRV63 into production. Can someone assist me with this issue?

Chuck-

Just curious if you figured this out. I have the exact same problem and can't figure out how to resolve it.

Thanks!

Laura

|||

Hi Laura. I was a bit surprised that I did not receive any response to help me with this issue as I was sure I was not the first to have experienced this issue. As I was short on time; I opted to reinstall Reporting Services and recreated all my user / group folders and securities and re-registered all my reports to the correct report folders. It was like starting from scratch; however it works and I do not have to worry about legacy items from the old server causing issues now. I believe I could have avoided this issue by turning off the Reporting Services on the old server before installing them on the new server therefore only the new Reporting Services instance would show. You might give this a try and see if it works. Sorry I don't have a more definitive answer for you.

Good luck.

|||

I was also able to solve the problem by deleting the report databases and then recreating them through the Reporting Services Configuration. Thanks for your response!

Laura

sql

Error running RS 2005.

I just finished to install Sql server 2005 with Reporting Services but
when I try to open http://localhost/Reports/Pages/Folder.aspx I get
the following error:
The underlying connection was closed: An unexpected error occurred on
a receive.
System.Net.WebException: The underlying connection was closed: An
unexpected error occurred on a receive. --> System.IO.IOException:
Unable to read data from the transport connection: An established
connection was aborted by the software in your host machine. -->
System.Net.Sockets.SocketException: An established connection was
aborted by the software in your host machine
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset,
Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32
offset, Int32 size)
-- End of inner exception stack trace --
at System.Net.ConnectStream.Read(Byte[] buffer, Int32 offset, Int32
size)
at System.Net.HttpWebRequest.MakeMemoryStream(Stream stream)
-- End of inner exception stack trace --
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
leve)
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!3/22/2007-17:43:59:: 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)
aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: The underlying connection
was closed: An unexpected error occurred on a receive.
aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: HTTP status code --> 500
Please, can someone help me?
Thank you!!On Mar 22, 4:20 pm, "Gabe" <vasgabr...@.gmail.com> wrote:
> I just finished to install Sql server 2005 with Reporting Services but
> when I try to openhttp://localhost/Reports/Pages/Folder.aspxI get
> the following error:
> The underlying connection was closed: An unexpected error occurred on
> a receive.
> System.Net.WebException: The underlying connection was closed: An
> unexpected error occurred on a receive. --> System.IO.IOException:
> Unable to read data from the transport connection: An established
> connection was aborted by the software in your host machine. -->
> System.Net.Sockets.SocketException: An established connection was
> aborted by the software in your host machine
> at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset,
> Int32 size, SocketFlags socketFlags)
> at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32
> offset, Int32 size)
> -- End of inner exception stack trace --
> at System.Net.ConnectStream.Read(Byte[] buffer, Int32 offset, Int32
> size)
> at System.Net.HttpWebRequest.MakeMemoryStream(Stream stream)
> -- End of inner exception stack trace --
> 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
> leve)
> 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!3/22/2007-17:43:59:: 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)
> aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: The underlying connection
> was closed: An unexpected error occurred on a receive.
> aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: HTTP status code --> 500
> Please, can someone help me?
> Thank you!!
You might want 2 try re-installing SQL Server 2005.
Regards,
Enrique Martinez
Sr. Software Consultant|||Please see if this helpful:
http://support.microsoft.com/default.aspx/kb/919797
"Gabe" wrote:
> I just finished to install Sql server 2005 with Reporting Services but
> when I try to open http://localhost/Reports/Pages/Folder.aspx I get
> the following error:
> The underlying connection was closed: An unexpected error occurred on
> a receive.
> System.Net.WebException: The underlying connection was closed: An
> unexpected error occurred on a receive. --> System.IO.IOException:
> Unable to read data from the transport connection: An established
> connection was aborted by the software in your host machine. -->
> System.Net.Sockets.SocketException: An established connection was
> aborted by the software in your host machine
> at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset,
> Int32 size, SocketFlags socketFlags)
> at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32
> offset, Int32 size)
> -- End of inner exception stack trace --
> at System.Net.ConnectStream.Read(Byte[] buffer, Int32 offset, Int32
> size)
> at System.Net.HttpWebRequest.MakeMemoryStream(Stream stream)
> -- End of inner exception stack trace --
> 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
> leve)
> 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!3/22/2007-17:43:59:: 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)
> aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: The underlying connection
> was closed: An unexpected error occurred on a receive.
> aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: HTTP status code --> 500
> Please, can someone help me?
> Thank you!!
>|||Thanks for response. The above link did not help me because I have Window
2000 professional with SP 4. Besides, I installed again both, SQL Server
2005 and VS 2005 and http://localhost/Reports worked in correct way. But
today I got the same error than before. I don't know what is happening. Can
someone help me please?
Thank you.
"Bruce Johnson [MSFT]" <BruceJohnsonMSFT@.discussions.microsoft.com> wrote in
message news:C02AD249-71FD-4A77-B813-CB150E6BEC0D@.microsoft.com...
> Please see if this helpful:
> http://support.microsoft.com/default.aspx/kb/919797
>
> "Gabe" wrote:
> > I just finished to install Sql server 2005 with Reporting Services but
> > when I try to open http://localhost/Reports/Pages/Folder.aspx I get
> > the following error:
> >
> > The underlying connection was closed: An unexpected error occurred on
> > a receive.
> >
> > System.Net.WebException: The underlying connection was closed: An
> > unexpected error occurred on a receive. --> System.IO.IOException:
> > Unable to read data from the transport connection: An established
> > connection was aborted by the software in your host machine. -->
> > System.Net.Sockets.SocketException: An established connection was
> > aborted by the software in your host machine
> > at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset,
> > Int32 size, SocketFlags socketFlags)
> > at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32
> > offset, Int32 size)
> > -- End of inner exception stack trace --
> > at System.Net.ConnectStream.Read(Byte[] buffer, Int32 offset, Int32
> > size)
> > at System.Net.HttpWebRequest.MakeMemoryStream(Stream stream)
> > -- End of inner exception stack trace --
> > 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
> > leve)
> > 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!3/22/2007-17:43:59:: 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)
> > aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: The underlying connection
> > was closed: An unexpected error occurred on a receive.
> > aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: HTTP status code --> 500
> >
> > Please, can someone help me?
> > Thank you!!
> >
> >