Link to home
Start Free TrialLog in
Avatar of Bruce
BruceFlag for United States of America

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?
SOLUTION
Avatar of Chris Luttrell
Chris Luttrell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bruce

ASKER

Here is the error...

(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.GetRequestStream()
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSecureMethods()
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
   at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
   at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
   at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
   at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()

===================================

No connection could be made because the target machine actively refused it (System)

------------------------------
Program Location:

   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
   at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
Avatar of Bruce

ASKER

I can connect to the database where the Reporting Services database resides.  

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.
Avatar of Bruce

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?

ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bruce

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.
Avatar of Bruce

ASKER

Thanks ezraa and CGLuttrell!