SSRS 2008 Report Manager Error

Posted by Nick on Stack Overflow See other posts from Stack Overflow or by Nick
Published on 2010-03-19T21:38:58Z Indexed on 2010/03/19 21:41 UTC
Read the original article Hit count: 767

Filed under:

ssrs

|

ssrs-2008

|

reporting-services

I have just installed SQL Server 2008 including Reporting Services on Windows Server 2003. I'm having a problem though accessing the Report Manager. When the Reporting Service is first started I can access it fine but after maybe an hour when I try and access it I get an error saying: Unable to connect to the remote server.

The reporting service is still running at this point. I can connect to it through Reporting Services Configuration Manager and clicking on the Web Service URL gives a directory listing (I assume that is correct behaviour). If I stop and start the service through Reporting Services Configuration Manager then I can access Report Manager once again (although in maybe an hour I will get the same error once again).

I've installed the latest SP1 service pack. I'm using the same domain account to run all the SQL services. The report server is set to use the default ReportServer virtual directory, is set to IP address All Assigned, TCP Port 80 and no SSL certificate. The report manager is set to use the default Reports virtual directory, IP address All Assigned, TCP Port 80 and no SSL certificates.

In the log file I get an error:

Unable to connect to remote server HTTP status code 500

An attempt was made to access a socket in a way forbidden by its access permissions.

Does anyone have any idea why this is happening? I've searched the net but haven't been able to find a solution.

© Stack Overflow or respective owner

Related posts about ssrs

Force SSRS 2008 to use SSRS 2005 CSV rendering

as seen on Stack Overflow - Search for 'Stack Overflow'
We are upgrading our report server from SSRS 2005 to SSRS 2008 R2. I have an issue with CSV export rendering for SSRS 2008 where the SUM of columns are appearing on the right side of the detail values in 2008 instead of the left side like in 2005 as shown in the below blocks. 117 and 131 are the sums… >>> More
SQL SERVER – What is SSRS and Why SSRS is asked for in many Job Opening?

as seen on SQL Authority - Search for 'SQL Authority'
This example is from the Beginning SSRS by Kathi Kellenberger. Supporting files are available with a free download from the www.Joes2Pros.com web site. This will be a 5 day blog post in getting started with SSRS. Today will show the importance of SSRS in the business. Why is SSRS asked for in so… >>> More
SSRS & asp.net - passing parameters from .net to ssrs in report viewer

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello all. I am about to embark in using a report viewer in my .net page. I have a page that will search for a catgory, upon a button click, the category chosen will pass into the parameter of report viewer. Now, given that I am a newbie to both SSRS and .net, I'd just like a bit of advice on how… >>> More
How to convert SSRS 2008 Server reports to SSRS 2008 Client Reports

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a large SSRS 2008 Server Report Project (more than 200 reports). Currently my companystrategy has been changed and we want to convert these server reports to client reports. All of the Server reports uses Storeprocedures (or in some cases from the SQl Functions) All of them work properly… >>> More
SSRS Report Viewer page hosted on HTTPS site, accessing SSRS Report server without SSL

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a scenario where an asp.net page is using the SSRS reportviewer control to display a report. we recently updated the IIS server to use an SSL certificate and now the same application has a HTTPS URL. Is it now, necessary to setup SSL certificate on the SSRS Report Server box as well? Or… >>> More

Related posts about ssrs-2008

How to convert SSRS 2008 Server reports to SSRS 2008 Client Reports

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a large SSRS 2008 Server Report Project (more than 200 reports). Currently my companystrategy has been changed and we want to convert these server reports to client reports. All of the Server reports uses Storeprocedures (or in some cases from the SQl Functions) All of them work properly… >>> More
iPhone - Open excel from SSRS 2008

as seen on Server Fault - Search for 'Server Fault'
We're currently having a problem with our 2008 SSRS server sending excel reports to users with iPhones. They get the email with no problems, but when the XLS file is opened on the phone, it returns an error of: Invalid format. Everyone else can open the report with no problems (email/blackberry) The… >>> More
SSRS 2008 Report Manager Error

as seen on Stack Overflow - Search for 'Stack Overflow'
I have just installed SQL Server 2008 including Reporting Services on Windows Server 2003. I'm having a problem though accessing the Report Manager. When the Reporting Service is first started I can access it fine but after maybe an hour when I try and access it I get an error saying: Unable to… >>> More
How to disable SSRS 2008 manager

as seen on Stack Overflow - Search for 'Stack Overflow'
Can you disable the SSRS 2008 manager (http://mydomain/reports), while leaving the report server working (http://mydomain/reportserver)? EDIT: Got it! This is how you do it in SSRS: Turn off Report Manager >>> More
Force SSRS 2008 to use SSRS 2005 CSV rendering

as seen on Stack Overflow - Search for 'Stack Overflow'
We are upgrading our report server from SSRS 2005 to SSRS 2008 R2. I have an issue with CSV export rendering for SSRS 2008 where the SUM of columns are appearing on the right side of the detail values in 2008 instead of the left side like in 2005 as shown in the below blocks. 117 and 131 are the sums… >>> More