‘Unable to connect to the remote server’ error when try to open SQL reporting link

 

You may get an error while configuring the reporting service and opening the reporting service URL stating that ‘Unable to connect to the remote server’. This error normally visible when you change the default reporting DB name or reporting URL.

Solution

From the SQL server where you have reporting DBs configured,

1. Go to the ReportServer folder [By default its C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer]

2. Locate the file ‘rSreportServer.config’
   
3. Open ‘rSreportServer.config’ in notepad and search for ‘SecureConnectionLevel’ and set the value to “0”
   
4. Save the file and close it.
5. Now try opening the URL it will be opening without any issue.