Could not connect to the report server http://localhost/reportserver

Question

Post reply

Could not connect to the report server http://localhost/reportserver

Naidu PK

SSCrazy

Points: 2481
More actions
March 21, 2013 at 4:11 pm

#272473

I currently have SQL2k8 R2 Reporting services on client machine (Windows 7). I created and deployed reports on this machine. Everything works perfect. I need to move everything to Server machine (W2k8 R2). I installed SQL2k8 R2 and copied the solution have that I have on client machine.
I can open rdl files on server machine but when I deploy reports I get the below error:
******************
TITLE: Microsoft SQL Server Report Designer
------------------------------
Could not connect to the report server http://localhost/ReportServer. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server.
------------------------------
ADDITIONAL INFORMATION:
Unable to connect to the remote server (System)
*********************
I compared server to client machine and checked all the settings are similar in RS configuration manager. However, After I connect to report server, I get similar error (precisely: 'unable to connect to remote server') when I expand any of nodes (Jobs, Security etc).
Similar error when I open http://localhost/ReportServer in internet explorer.
I tried running RS with domain account, network service account, local system account but of no luck.
What else could I be missing here ?
Thanks,
Naveen.
Every thought is a cause and every condition an effect
March 26, 2013 at 4:54 am

This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

super48 SSCrazy Points: 2682 More actions · Answer 1

I THINK Problem is because of server name or URL may be wrong

check the project URL and change it to the URL same as in

report configuration manager.

then deploy

Naidu PK SSCrazy Points: 2481 More actions · Answer 2

Well, I got the solution from msdn. On my windows server, I did below steps:

1. In the reporting services configuration manager, click web service url. Removed the SSL certificate to the port 443 by clicking advanced button.

2. open the rsreportserver.config file at C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ (file path may be differ based on SQL Server version). Open with administrator privileges.

3. Update and save SecureConnectionLevel field to 0 (initial value is 2) as below:

Then I am able to deploy my reports. I now see a different issue in accessing my data sources.

When I open the report in the browser, I dont see data sources listed and when I click report I see below error:

"

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'abcd'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

"

Thanks,
Naveen.
Every thought is a cause and every condition an effect

super48 SSCrazy Points: 2682 More actions · Answer 3

I think you have to change the data base name in data source...