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?
Who is Participating?
ezraaConnect With a Mentor Commented:
Re: Credential settings
When you deploy the report, Visual Studio is logging in to the Reporting server with the credentials you used to log into windows on the development machine. Make sure that that user has access to the reporting server.  The credentials that you are talking about is for connecting to SQL when the report runs --- after it is deployed.

It doesn't sound like a permissions issue to me.  Are you using the same port (8085) when browsing to the server?  Double check the that you have set up your Reporting Services server information correctly:

In the properties of the Project make sure that TargetServerURL is entered as:  http://YourReportServer:port/ReportServer  
(I don't know how you have set up your server, this should be the ReportServer url and not the report manager url)

Also, do you have any firewalls running?  
Chris LuttrellConnect With a Mentor Senior Database ArchitectCommented:
Have you tried to run the report from the local machine that host Reportin Server, that will sometimes give you more or better info on what the error is.  This may be an issue with your datasource values, have you checked them and verified you can connect to the database where the data resides from this box?  You do not need to set up a linked server, but the database has to allow remote connections.
BruceAuthor Commented:
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)
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

BruceAuthor Commented:
I can connect to the database where the Reporting Services database resides.  

Could this be a permissions issue?
Chris LuttrellSenior Database ArchitectCommented:
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.
BruceAuthor Commented:
"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?

BruceAuthor Commented:
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.
BruceAuthor Commented:
Thanks ezraa and CGLuttrell!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.