Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to access SSRS 2008R2 Repots from Remote Server to my App Server Expand / Collapse
Author
Message
Posted Wednesday, May 30, 2012 12:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 14, 2012 4:10 AM
Points: 1, Visits: 26
Hi techies,

I have been trying for SSRS 2008R2 reports access from one of my server which are delpoyed on it (O.S windows 2008 R2 server) to my web application which is hosted on another server(O.S windows 2008 R2 server) ..I tried it by using reportviewer and also by passing the server credentials.

Code :
ReportViewer1.ShowCredentialPrompts = false;
ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://IP:80/ReportServer");
ReportViewer1.ServerReport.ReportPath = "/EmployeeRpt/Employee List";
ReportViewer1.ProcessingMode = ProcessingMode.Remote;
IReportServerCredentials irsc = new CustomReportCredentials("User Name", "Password", "domain");
ReportViewer1.ServerReport.ReportServerCredentials = irsc;
ReportViewer1.ShowParameterPrompts = true;
ReportViewer1.ShowPrintButton = true;
ReportViewer1.ServerReport.DisplayName = "/EmployeeRpt/Employee List";
ReportViewer1.ServerReport.Refresh();

I am getting an error :

Unable to connect to the remote server
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond IPAddess:80

plzz can any one help me..
Post #1308122
Posted Wednesday, February 20, 2013 12:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 12:48 AM
Points: 2, Visits: 3
Hi Srikanth,

I am facing the same problem. Can you please share the solution if you have found any?

Regards,
Amit Waghchoure
Post #1421950
Posted Wednesday, February 20, 2013 12:45 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:32 AM
Points: 644, Visits: 1,299
Amit,

This looks like an old thread, still

Mostly the problem would be firewall.
Look what port is configured in Reporting services configuration manager (Or ask your DBA).
Ask your network folks to open these ports for you


-- Roshan Joe
*******************************************
There are two types of DBAs. Those who has skills and those who have permissions
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups
Post #1421955
Posted Wednesday, February 20, 2013 12:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 12:48 AM
Points: 2, Visits: 3
Hi Roshan,
Thanks for the reply. I will check the network settings as suggested by you.

Regards,
Amit.
Post #1421957
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse