SSRS 2014 - Unable to connect to the remote server

Question

 Hi

I installed SSRS 2014 (without IIS) on my server and am using SQL Server 2008 as backend database.

I am able to access http://local/Reports/Pages/Folder.aspx without any issue.

Then, I configured SSL on report server manager and tried to access the https://local/Reports/Pages/Folder.aspx and am getting below error:

"Unable to connect to the remote server"

how can I resolve this issue?

Thanks.

Answer 1

Hi H1351,

The following worked for me: 1. Remove the SSL if configured. 2. Go to C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config 3. In rsreportserver.config Change the SecureConnectionLevel value from "2" to "0"

Refer more detials in folowing links

http://stackoverflow.com/questions/9074019/unable-to-connect-to-the-remote-server-when-connected-via-net-reportingservic

https://msdn.microsoft.com/en-us/library/ms365170.aspx?f=255&MSPPError=-2147217396

---

Please click Mark As Answer if my post helped.

Answer 2

Hi H1351,

The following worked for me: 1. Remove the SSL if configured. 2. Go to C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config 3. In rsreportserver.config Change the SecureConnectionLevel value from "2" to "0"

Refer more detials in folowing links

http://stackoverflow.com/questions/9074019/unable-to-connect-to-the-remote-server-when-connected-via-net-reportingservic

https://msdn.microsoft.com/en-us/library/ms365170.aspx?f=255&MSPPError=-2147217396

---

Please click Mark As Answer if my post helped.

Thanks Dinesh for answer, but I need to enable SSL certificate .I have no problem with HTTP.

Answer 3

Hi H1351,

According to your description, you want to enable SSL certificate in Reporting Service. However you got an error when you configured the SSL. Right?

Since the error is so generic. Please share us your Reporting Service error log files under the path like: C:\Program
Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles for more detailed information. 

Also, you can refer to following articles see if you have missed some steps during the configuration.

Configure SSL Connections on a Native Mode Report Server 

A step-by-step example of configuring a reporting services point for HTTPS in System Center 2012 Configuration Manager 

If you still have any questions, please feel free to ask.

Thanks,

Xi JIn.

Answer 4

Thanks XI,

based on second link that you send,Requirements for SSL is :

"NOTE The Report Server instance and ConfigMgr Site Database instance can be on different servers but they must be the same version in order to communicate properly."

I am not sure if this is my case .I have different version of SSRS 2014 (front) and MS SQL Server 2008R2  (backend), but I haven't seen any Microsoft document that confirm it.

Thanks,

Heidar

Answer 5

Hi H1351,

So in your scenario, did you mean that your report server database is stored on a SQL Server 2008R2 instance? If so, I would suggest you change your report server database to a 2014 one. And configure the SSL connection again to see if the issue persists.

If you still have any questions, please feel free to ask.

Thanks,

Xi Jin.