Bruce
asked on
A connection could not be made to the report server http://... Unable to connect to the remote server (System)
I am trying to deploy a report created in BIDS/Report Designer/VStudio and am getting an error...
"A connection could not be made to the report server http://..." "Unable to connect to the remote server (System)"
I can bring up in IE the Report Manager http://ReportServerName/reports and see the three folders I have created there in the Report Manager GUI page. When I browse to the "ReportServer" I also see the 3 folders (in a directory listing page style).
The report I am trying to deploy works in the Report Designer.
My Reporting Services server is setup on one windows 2003 server and the database is setup on another. Do I need to establish a "linked server" in order to make this work?
Where do I go from here to debug this problem?
"A connection could not be made to the report server http://..." "Unable to connect to the remote server (System)"
I can bring up in IE the Report Manager http://ReportServerName/reports and see the three folders I have created there in the Report Manager GUI page. When I browse to the "ReportServer" I also see the 3 folders (in a directory listing page style).
The report I am trying to deploy works in the Report Designer.
My Reporting Services server is setup on one windows 2003 server and the database is setup on another. Do I need to establish a "linked server" in order to make this work?
Where do I go from here to debug this problem?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I can connect to the database where the Reporting Services database resides.
Could this be a permissions issue?
Could this be a permissions issue?
Does sound like a permission or configuration issue. Have you double checked the Report Server Configuration and its DB connection settings? Sorry, this is one of those that is hard to see the problem when you can't walk through all the steps yourself.
ASKER
"Sorry, this is one of those that is hard to see the problem..." No, no thank you. Any help is greatly appreciated!
Yes, the Reporting Services Config Mgr says the Database Setup is good. What should my credentials setting be? I think I left it as the default ("Service Credentials") when I did the setup initially. That is what it is currently set to. Since I am operating this on separate servers should that be setup differently?
Yes, the Reporting Services Config Mgr says the Database Setup is good. What should my credentials setting be? I think I left it as the default ("Service Credentials") when I did the setup initially. That is what it is currently set to. Since I am operating this on separate servers should that be setup differently?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Deployment succeeded!
I am pretty sure it was add "ReportServer" to the end of my URL in the TargetServerURL
Thanks ezraa!
I have a datasource issue now but I'll post that one separately.
I am pretty sure it was add "ReportServer" to the end of my URL in the TargetServerURL
Thanks ezraa!
I have a datasource issue now but I'll post that one separately.
ASKER
Thanks ezraa and CGLuttrell!
ASKER
(Sorry, I meant to post this with the original question)
==========================
A connection could not be made to the report server http://ReportServerName:8085/. (Microsoft Report Designer)
==========================
Unable to connect to the remote server (System)
--------------------------
Program Location:
at System.Net.HttpWebRequest.
at System.Web.Services.Protoc
at Microsoft.SqlServer.Report
at Microsoft.SqlServer.Report
at Microsoft.SqlServer.Report
at Microsoft.SqlServer.Report
at Microsoft.ReportDesigner.P
at Microsoft.ReportDesigner.P
at Microsoft.ReportDesigner.P
at Microsoft.ReportDesigner.P
==========================
No connection could be made because the target machine actively refused it (System)
--------------------------
Program Location:
at System.Net.Sockets.Socket.
at System.Net.Sockets.Socket.
at System.Net.ServicePoint.Co