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?
LVL 1
BruceAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chris LuttrellSenior 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.
0
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)
0
BruceAuthor Commented:
I can connect to the database where the Reporting Services database resides.  

Could this be a permissions issue?
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

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.
0
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?

0
ezraaCommented:
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?  
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
0
BruceAuthor Commented:
Thanks ezraa and CGLuttrell!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.