Friday, March 30, 2012
ReportViewer error with SSRS2005 on a non-default website
ASP.NET 2.0 WebForms control. The reportviewer displays an error "The attempt
to connect to the report server failed. Check your connection information and
that the report server is a compatible version. The request failed with HTTP
status 404: Not Found". When I try to access any of the SSRS2005 Web Service
method (For example: ListChildren) with a proxy, I get an error "The request
failed with HTTP status 404: Not Found."
Here are the exception details:
-----
{"The request failed with HTTP status 404: Not Found."}
[System.Net.WebException]: {"The request failed with HTTP status 404:
Not Found."}
Data: {System.Collections.ListDictionaryInternal}
HelpLink: null
InnerException: null
Message: "The request failed with HTTP status 404: Not Found."
Source: "Test.MDC.CRI.SSRS2005.Helper"
StackTrace: " at
Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildren(String parentFolder,
Boolean recursive, CatalogItem[]& items) in
C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
252\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildrenByType(String
parentFolder, ItemTypeEnum itemType, Boolean ignoreDatasourceFolder,
SortedList& childItems) in
C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
105\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetFolders(String
parentFolder, Boolean ignoreDatasourceFolder, SortedList& childFolders) in
C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line 26\r\n
at BrowseFolders.Page_Load(Object sender, EventArgs e) in
c:\\SSRS\\CRI\\Prototype2\\ReportViewerWebClient\\UserCtls\\BrowseFolders.ascx.cs:line
33\r\n at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp,
Object o, Object t, EventArgs e)\r\n at
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e)\r\n at System.Web.UI.Control.OnLoad(EventArgs e)\r\n at
System.Web.UI.Control.LoadRecursive()\r\n at
System.Web.UI.Control.LoadRecursive()\r\n at
System.Web.UI.Control.LoadRecursive()\r\n at
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
Boolean includeStagesAfterAsyncPoint)"
TargetSite: {Boolean GetChildren(System.String, Boolean,
Test.MDC.CRI.SSRS2005.WebService.CatalogItem[] ByRef)}
-----
Response object of System.Net.WebException:
-----
{System.Net.HttpWebResponse}
[System.Net.HttpWebResponse]: {System.Net.HttpWebResponse}
base {System.MarshalByRefObject}: {System.Net.HttpWebResponse}
ContentLength: 629
ContentType: "text/html"
Headers: {Pragma: no-cache
Proxy-Connection: Keep-Alive
Connection: Keep-Alive
Content-Length: 629
Cache-Control: no-cache
Content-Type: text/html
}
IsFromCache: false
IsMutuallyAuthenticated: false
ResponseUri:
{http://ssrs.dev.reports.com:8084/ReportServer/ReportService2005.asmx}
-----
My Report Server configuration:
Web Server: Windows 2003 Standard SP1
SQL Server: SQL Enterprise 2005 SP1
Report Server Web Site: Installed on a non-default web site, running under
ASP.NET 2.0, part of app pool with identity NetWork Service
Reporting Services Windows Service running under Local System account
Identity of the web site: Anonymous access disabled, Windows Authentication
checked
Reports virtual directory - Integrated Windows Authentication, Anonymous
disabled
ReportServer virtual directory - Integrated Windows Authentication,
Anonymous disabled
Patches:
1. Disable loopback entry set as per MSKB article:
http://support.microsoft.com/kb/896861/
2. RSWebApplication.config changed as below:
Before:
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
After:
<UI>
<ReportServerUrl>http://ssrs.dev.reports.com:8084/ReportServer</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
The following sites runs OK.
- http://ssrs.dev.reports.com:8084/ReportServer/ (Able to deploy reports
to this using VS2005 designer. Currently displays the version Microsoft SQL
Server Reporting Services Version 9.00.2047.00)
- http://ssrs.dev.reports.com:8084/Reports/ (Displays deployed reports and
able to browse folders)
If you can help me to fix the issue, it would be of great help. Struggling
for few days already with this issue.
Thanks,
Live_Love_LaughOne more thing to mention:
After playing with SSRS2005 for few days, I figured out that if the
WebApplication is running of file system(ASP.NET 2.0 feature), rather than on
a website I could able to see the results through report viewer control but
as soon as I put it on IIS, I am getting the error "The attempt to connect to
the report server failed. Check your connection information and that the
report server is a compatible version. The request failed with HTTP status
404: Not Found."
Any ideas?
Thanks,
Live_Love_Laugh
"Live_Love_Laugh" wrote:
> I am facing a problem when trying to access a report using ReportViewer
> ASP.NET 2.0 WebForms control. The reportviewer displays an error "The attempt
> to connect to the report server failed. Check your connection information and
> that the report server is a compatible version. The request failed with HTTP
> status 404: Not Found". When I try to access any of the SSRS2005 Web Service
> method (For example: ListChildren) with a proxy, I get an error "The request
> failed with HTTP status 404: Not Found."
> Here are the exception details:
> -----
> {"The request failed with HTTP status 404: Not Found."}
> [System.Net.WebException]: {"The request failed with HTTP status 404:
> Not Found."}
> Data: {System.Collections.ListDictionaryInternal}
> HelpLink: null
> InnerException: null
> Message: "The request failed with HTTP status 404: Not Found."
> Source: "Test.MDC.CRI.SSRS2005.Helper"
> StackTrace: " at
> Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildren(String parentFolder,
> Boolean recursive, CatalogItem[]& items) in
> C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
> 252\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildrenByType(String
> parentFolder, ItemTypeEnum itemType, Boolean ignoreDatasourceFolder,
> SortedList& childItems) in
> C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
> 105\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetFolders(String
> parentFolder, Boolean ignoreDatasourceFolder, SortedList& childFolders) in
> C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line 26\r\n
> at BrowseFolders.Page_Load(Object sender, EventArgs e) in
> c:\\SSRS\\CRI\\Prototype2\\ReportViewerWebClient\\UserCtls\\BrowseFolders.ascx.cs:line
> 33\r\n at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp,
> Object o, Object t, EventArgs e)\r\n at
> System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
> EventArgs e)\r\n at System.Web.UI.Control.OnLoad(EventArgs e)\r\n at
> System.Web.UI.Control.LoadRecursive()\r\n at
> System.Web.UI.Control.LoadRecursive()\r\n at
> System.Web.UI.Control.LoadRecursive()\r\n at
> System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
> Boolean includeStagesAfterAsyncPoint)"
> TargetSite: {Boolean GetChildren(System.String, Boolean,
> Test.MDC.CRI.SSRS2005.WebService.CatalogItem[] ByRef)}
> -----
> Response object of System.Net.WebException:
> -----
> {System.Net.HttpWebResponse}
> [System.Net.HttpWebResponse]: {System.Net.HttpWebResponse}
> base {System.MarshalByRefObject}: {System.Net.HttpWebResponse}
> ContentLength: 629
> ContentType: "text/html"
> Headers: {Pragma: no-cache
> Proxy-Connection: Keep-Alive
> Connection: Keep-Alive
> Content-Length: 629
> Cache-Control: no-cache
> Content-Type: text/html
> }
> IsFromCache: false
> IsMutuallyAuthenticated: false
> ResponseUri:
> {http://ssrs.dev.reports.com:8084/ReportServer/ReportService2005.asmx}
> -----
> My Report Server configuration:
> Web Server: Windows 2003 Standard SP1
> SQL Server: SQL Enterprise 2005 SP1
> Report Server Web Site: Installed on a non-default web site, running under
> ASP.NET 2.0, part of app pool with identity NetWork Service
> Reporting Services Windows Service running under Local System account
> Identity of the web site: Anonymous access disabled, Windows Authentication
> checked
> Reports virtual directory - Integrated Windows Authentication, Anonymous
> disabled
> ReportServer virtual directory - Integrated Windows Authentication,
> Anonymous disabled
> Patches:
> 1. Disable loopback entry set as per MSKB article:
> http://support.microsoft.com/kb/896861/
> 2. RSWebApplication.config changed as below:
> Before:
> <UI>
> <ReportServerUrl></ReportServerUrl>
> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> After:
> <UI>
> <ReportServerUrl>http://ssrs.dev.reports.com:8084/ReportServer</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> The following sites runs OK.
> - http://ssrs.dev.reports.com:8084/ReportServer/ (Able to deploy reports
> to this using VS2005 designer. Currently displays the version Microsoft SQL
> Server Reporting Services Version 9.00.2047.00)
> - http://ssrs.dev.reports.com:8084/Reports/ (Displays deployed reports and
> able to browse folders)
>
> If you can help me to fix the issue, it would be of great help. Struggling
> for few days already with this issue.
> Thanks,
> Live_Love_Laugh
Wednesday, March 28, 2012
ReportViewer and HTTP 401
I have read a million documents on this question and I still don't get it. I would greatly appreciate any insights.
I start a new WebSite. I put these specs in web.config:
<authentication mode="Windows"/>
<identity impersonate="true" userName="AIB\ablh" password="blah" />
<authorization> <deny users="?"/> </authorization>
I put a ReportViewer control on my only page.
I set the URL and the ReportName and run the application which returns HTTP 401, authorization error. What else do I have to do to make this little demonstration work?
I have read entries about credentials, about delegation, about application pools, about just about everything.
Isn't this just supposed to work? This works without difficulty on a Windows form.
Much thanks.
Is your web application and Report Server on the same IIS box?
Do your virtual directories (Reports / ReportServer) have Anonymous checked or unchecked?
Does this happen if you run the web application on the server or just on a client (not the web server)?
Are the credentials you provide in the web.config domain or a machine specific windows account?
Monday, March 26, 2012
ReportViewer (web control) - parameter change refresh
I have created an ASP.NET website with a ReportViewer on. The report renders fine, but when I change one of the parameters (manually), the report seems to invalidate itself and a blank while area is drawn. I would like the same behaviour as in the WinForms variant, where rhe rendered report remains the same until the 'View Report' button is pressed.
Is this possible?
Regards Andreas
hi
i did the same thing integrating reporting services to web application but my problem is the viewer does not show anything but i can see it being generated and how many pages it's generated and when i click on the export menu format and export to excel the results shows on the excel file but not on the viewer,
does this has to do with setting up properties of the reportviewer?
please assist
sqlReportViewer (web control) - parameter change refresh
I have created an ASP.NET website with a ReportViewer on. The report renders fine, but when I change one of the parameters (manually), the report seems to invalidate itself and a blank while area is drawn. I would like the same behaviour as in the WinForms variant, where rhe rendered report remains the same until the 'View Report' button is pressed.
Is this possible?
Regards Andreas
hi
i did the same thing integrating reporting services to web application but my problem is the viewer does not show anything but i can see it being generated and how many pages it's generated and when i click on the export menu format and export to excel the results shows on the excel file but not on the viewer,
does this has to do with setting up properties of the reportviewer?
please assist
Friday, March 23, 2012
ReportServer Website
Ok, I have this up and running thanks to the help of lots of users in this forum (Thank You again)
I deployed some reports, and everything looks fine, however to add another twist to this, I would like the website to look prettier, by adding something like a welcome page,and some folders and such.
Does anyone have any ideas on how to do that ? DO you have any material or a website, where I can get some info ?
Thanks
Which site? The Report Manager? It supports limited costomization through CSS styles (see C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\Styles)
ReportServer Site error
Hi, i installed SQL Server with Reporting Services... when i try to access the ReportServer website i get this error. Can someone help me?
Server Error in '/ReportServer' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot\web.config' because access is denied.
Source Error:
[No relevant source lines]Source File: c:\inetpub\wwwroot\web.config Line: 0
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
If you see, it says that the source file is "c:\inetpub\wwwroot\web.config" but my ReportServer document root is in other place, i've tried coping the web.config file to wwwroot, but nothing.
I guess you need to add permissions to your root folder which is wwwroot. Right click on the folder and in the Security tab, add MachineName\ASPNET user to the list and give all permission to that user.
Shyam
|||i've done what you sayed, but everything stayed the same... The report server service is runing under Local System account, also gave it permission but still nothing happend... i really need help since i've to install Microsoft CRM and it needs a running Report Server|||I guess this link will be helpful for you:
http://blog.devstone.com/Aaron/archive/2004/12/03/359.aspx
Shyam
|||did that with some differences since i'm at a domain controller... nothing happened... thanks for the fast answer...|||So, is your problem solved? Can the post be marked as answer?|||i still have the same problem.... i followed the page you posted me but nothing happened...|||Then try the last resort, which is to restart the machine. I'm sorry for this cliche in the Microsoft community.
Shyam
|||sorry, i've tried, and sorry if i wait 'till the mornings to answer, but the only time i've got to try to fix this problem is at nights when there aren't users, thanks for all your help but, the problem is still thereReportServer Site error
Hi, i installed SQL Server with Reporting Services... when i try to access the ReportServer website i get this error. Can someone help me?
Server Error in '/ReportServer' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot\web.config' because access is denied.
Source Error:
[No relevant source lines]Source File: c:\inetpub\wwwroot\web.config Line: 0
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
If you see, it says that the source file is "c:\inetpub\wwwroot\web.config" but my ReportServer document root is in other place, i've tried coping the web.config file to wwwroot, but nothing.
I guess you need to add permissions to your root folder which is wwwroot. Right click on the folder and in the Security tab, add MachineName\ASPNET user to the list and give all permission to that user.
Shyam
|||i've done what you sayed, but everything stayed the same... The report server service is runing under Local System account, also gave it permission but still nothing happend... i really need help since i've to install Microsoft CRM and it needs a running Report Server|||I guess this link will be helpful for you:
http://blog.devstone.com/Aaron/archive/2004/12/03/359.aspx
Shyam
|||did that with some differences since i'm at a domain controller... nothing happened... thanks for the fast answer...|||So, is your problem solved? Can the post be marked as answer?|||i still have the same problem.... i followed the page you posted me but nothing happened...|||Then try the last resort, which is to restart the machine. I'm sorry for this cliche in the Microsoft community.
Shyam
|||sorry, i've tried, and sorry if i wait 'till the mornings to answer, but the only time i've got to try to fix this problem is at nights when there aren't users, thanks for all your help but, the problem is still thereReportServer service won't start, and gettign website error
I';ve had an installation of reporting services running fine for months
now. This morning, I started getting the following error when trying to
access the report manager:
"Unable to communicate with report server. Please verify that the
report server is operational"
Also, the ReportServer service won't start. I get an error back saying
that "the service did not return an error", which is nice and helpful.
Any ideas what would cause this?Go to IIS make sure no one deleted the folder called ReportServer
Wednesday, March 21, 2012
Reports without Dataset ?
Hi,
I want to create SQL reports without using typedDataset.
Here is my scenario..
I am building a 3-tier arch website. On my web layer I want to display few reports and as a datasource I want to use my business objects which lays in buisness layer classes as methods. These methods returns DataTable.
I want to use this methods as datasource for my reports without getting dataset in picture. My problem is that while desinging report, it is taking Dataset as default datasource and its building it in App code. I don't want this, instead, I want to point my reports to Object Data Source and ODS to my business objects.
Is it possible to get rid of DataSet completly while designing reports? If yes than How to do it?
Thanks in advance
Regards,
ND
Hi,
From your description, it seems that you want to use the dataset as the datasource of your report project, right?
Based on my understanding, you can create a webservice which returns the dataset, and then regard the dataset as the datasource of your report. And then, in that webservice, you can call the methods which comes from your business layer to get the data you need.
For detail:
1. Create a webservice project, and create a webmethod, and then add the reference of your business class, and invoke the methods to get the data, create an dataset which is used to contain the data from your business layer. After that, you should deploy the webservice in your IIS.
2. Create a reporting service project, and then crate a new datasource in the SharedDataSource, set the Type to XML, assign the connection String property with the webservice address you created just now.
3. Create a new report, assign the Query String as:
<Query xmlns="http://Eric.org/">
<SoapAction>http://Eric.org/GetDataSource</SoapAction>
</Query>
For more usage about QueryString, seehttp://msdn2.microsoft.com/en-us/library/ms345251.aspx
Thanks.
Thanks for the details..
Actually I don't want to use Dataset for my reports, How to achieve this?
While designing reports, It always creates Dataset and then display all the fields from the connected source. Instead of that, I want something what you mentioned in your reply but, WITHOUT using XML.
My scenario is the same, Its 3-tiers application, Fetching data by using WebService methods.
Regards,
ND
Tuesday, March 20, 2012
Reports Security--Windows authnetication
I have created a user and a link in our website which links to the report.
Now whenever anyone clicks the button to view the report,a prompt comes up
for Uers name & password. But if wrong password id enterd it shows Reporting
services error-- The permissions granted to the user are insufficient . See
rsOnline for help." Till yesterday, when the person entered a wrong user
name & password. It would prompt the user name & password again & again and
after 3-4 time it would take you to the page... "You are not authoized to
view the page..Plz click the refresh button..."
I tdont want the users to see any reporting svcs error but this general
error : "You are not authoized to view the page..Plz click the refresh
button..." > I think its related to IIS.
How to get over this?
--
pmudI hope you are using Form Authentication example from Microsoft site. All you
have to do is edit the UILogon.aspx page. You have to redirect to the page
where you say that user credential is invalid to see the report.
HTH
--
Rajesh
MCSD.NET
http://meenrajan.blogspot.com
"pmud" wrote:
> Hi,
> I have created a user and a link in our website which links to the report.
> Now whenever anyone clicks the button to view the report,a prompt comes up
> for Uers name & password. But if wrong password id enterd it shows Reporting
> services error-- The permissions granted to the user are insufficient . See
> rsOnline for help." Till yesterday, when the person entered a wrong user
> name & password. It would prompt the user name & password again & again and
> after 3-4 time it would take you to the page... "You are not authoized to
> view the page..Plz click the refresh button..."
> I tdont want the users to see any reporting svcs error but this general
> error : "You are not authoized to view the page..Plz click the refresh
> button..." > I think its related to IIS.
> How to get over this?
> --
> pmud
Monday, March 12, 2012
Reports (Manager) website errors with 404 and 500
directory and reports can be run. The Reports Manager website does not run.
The redirect to http://Server/Reports/Pages/Folder.aspx shows and a Red X
Error header followed by The request failed with HTTP status 404: Not Found.
The log shows:
w3wp!ui!7e8!6/3/2005-09:11:46:: e ERROR: The request failed with HTTP status
404: Not Found.
w3wp!ui!7e8!6/3/2005-09:11:46:: 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.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!7e8!6/3/2005-09:11:48:: 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)...
--
Keith Powers, MCDBAReport Manager can be run from Inside IIS Manager.
--
Keith Powers, MCDBA
"Keith Powers" wrote:
> Deploying reports works, Running ReportServer URL yields deployed reports
> directory and reports can be run. The Reports Manager website does not run.
> The redirect to http://Server/Reports/Pages/Folder.aspx shows and a Red X
> Error header followed by The request failed with HTTP status 404: Not Found.
> The log shows:
> w3wp!ui!7e8!6/3/2005-09:11:46:: e ERROR: The request failed with HTTP status
> 404: Not Found.
> w3wp!ui!7e8!6/3/2005-09:11:46:: 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.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!7e8!6/3/2005-09:11:48:: 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)...
> --
> Keith Powers, MCDBA
Saturday, February 25, 2012
Reporting Website Stops Responding - No Error Message
We've had SQL Reporting Services running for over 6 months. This week,
every day, we've experienced a problem where the RS website stops responding.
There's no page could not be displayed message or any other error message,
just an hour glass as the browser tries to go to the URL. Restarting IIS and
the Reporting Services service makes the site available again. There are no
error messages in the RS logs, just processing messages. The server is a
dedicated Windows 2003 Enterprise, 4-CPU server.
Anyone else had this problem?
Thanks,
JasonJason its really sad that microsoft staff has been ignoring your post over a
month now.
Maybe you should try their sp 1 for Reporting Services. I my opinion its an
rewrite of the whole application judging from the sheer size of the
downloaded file.
"Jason" wrote:
> Hello,
> We've had SQL Reporting Services running for over 6 months. This week,
> every day, we've experienced a problem where the RS website stops responding.
> There's no page could not be displayed message or any other error message,
> just an hour glass as the browser tries to go to the URL. Restarting IIS and
> the Reporting Services service makes the site available again. There are no
> error messages in the RS logs, just processing messages. The server is a
> dedicated Windows 2003 Enterprise, 4-CPU server.
> Anyone else had this problem?
> Thanks,
> Jason|||Going to SP1 is a good idea. Note that you have a misconception about the
newsgroup. You are only guaranteed a response from MS if you are using a
managed newsgroup account when you post a question. Otherwise it is peer
supported. A problem like this should go the route of MS support, if it is a
bug / hotfix then there is no charge from product support.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"It a shame" <It a shame@.discussions.microsoft.com> wrote in message
news:574870D8-8FA3-4D7C-B428-EB8CA7805AE0@.microsoft.com...
> Jason its really sad that microsoft staff has been ignoring your post over
a
> month now.
> Maybe you should try their sp 1 for Reporting Services. I my opinion its
an
> rewrite of the whole application judging from the sheer size of the
> downloaded file.
>
> "Jason" wrote:
> > Hello,
> >
> > We've had SQL Reporting Services running for over 6 months. This week,
> > every day, we've experienced a problem where the RS website stops
responding.
> > There's no page could not be displayed message or any other error
message,
> > just an hour glass as the browser tries to go to the URL. Restarting
IIS and
> > the Reporting Services service makes the site available again. There
are no
> > error messages in the RS logs, just processing messages. The server is
a
> > dedicated Windows 2003 Enterprise, 4-CPU server.
> >
> > Anyone else had this problem?
> >
> > Thanks,
> > Jason