Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Naveen PK
Naveen PK
Old Hand
Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)

Group: General Forum Members
Points: 364 Visits: 407
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
super48
super48
SSC Journeyman
SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)

Group: General Forum Members
Points: 83 Visits: 500
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
prettsons
prettsons
SSC-Enthusiastic
SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)

Group: General Forum Members
Points: 191 Visits: 1380
Please check this link : http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=154492

Hope it will solve your issue!!

SQL Database Recovery Expert :-)
Naveen PK
Naveen PK
Old Hand
Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)

Group: General Forum Members
Points: 364 Visits: 407
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:
<Add Key="SecureConnectionLevel" Value="0"/>

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
super48
SSC Journeyman
SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)

Group: General Forum Members
Points: 83 Visits: 500
I think you have to change the data base name in data source...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search