Wednesday, July 20, 2011

SSRS 2008 R2 - Unable to Connect to Remote Server Error

I had installed SQL Server 2008 R2 on windows 7, but could not able to connect to the report server at
http://pc-0260:13000/Reports

Try doing the following things
Go to Reporting Services Conf. Manager.

1. Change the server account to local account.
2. Remove the SSL if configured.
3. Go to C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer
4. Change the  SecureConnectionLevel value to 0 in rsreportserver.config

Try refreshing the page, it should work now!

6 comments:

Dibyendu Santra said...

Too Good...solved my problem..thanks

iancrm said...

Thank you, thank you, thank you. The vast majority of the info on the net is for older SSRS versions that don't apply. This was spot on for 2008 R2. Thanks.
IanCRM

Troy Koolhoven said...

Good stuff..

Thank so much...I killed about a day trying to figure out why SSRS R2 was unable to connect to the remote server...thanks for this posting ...this is solved my issue. Why doesnt Micorsoft include this on there install notes ?

Test said...

Awesome, thanks so much!!

smuralimanohar said...

thanks that worked like a charm.great post. thanks buddy

Alex said...

I spent lots of time and effort until I was thinking to search on-line...I blamed IP-s and ports and anything else.

Your solution of changing config file resolved the problem, I did not have to change the account.

If I could I would buy you multiple drinks for this solution :o)

Thanks a lot.