question

BrianCarisey-5104 avatar image
0 Votes"
BrianCarisey-5104 asked Joyzhao-MSFT commented

SSRS web service and web portal give error connection refused

Hello,
I'm trying to access the web portal from SSRS from chrome.
I'm using the machine on which the SSRS service is installed but it give me the error : err_connection_refused.
The configuration manager show me that the service is running.
What could cause that error to occur ?
Thank you in advance.

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered BrianCarisey-5104 commented

Hi @BrianCarisey-5104 ,
Please make sure the configuration is correct.

Could you try to open the report manager with another browser to troubleshoot Google Chrome?

If cannot be opened with other browsers , please check the error log. The log file path for 2017 and above versions is: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles
Error log is very helpful for resolving issue.

Modify the following information in the configuration file:

 <Add Key="SecureConnectionLevel" Value="0"/>

Its value was 2, changed it to 0.
The path of the rsreportserver.config file is located at: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer
If you have any question,please feel free to let me know.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for the help.
I went and took a look at the logs.
The log contains a warning : the Child Process [Management Service] Died.
I am unsure as to why that process keep dying but i think it's the cause of my problem.

0 Votes 0 ·

If possible, please copy the information in the "errors" section of the error log file. And could you attach your configuration information? So far, it’s hard to find out where the problem is.

0 Votes 0 ·

My configuration is the following :
The SQL server is SQL server 2017 standard, running on a windows server 2019 standard.
Attached is the 1st page of the report server configuration manager.78693-ssrs.png
I can't find the error on the log. Is it on another folder than the one you gave previously ?


0 Votes 0 ·
ssrs.png (4.9 KiB)
BrianCarisey-5104 avatar image
0 Votes"
BrianCarisey-5104 answered Joyzhao-MSFT commented

I found the solution.
The person that did the installation wrongly installed an evaluation version.
By installing the proper version the web service is working properly.
Thank you for the help.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I’m glad to hear that your issue has been resolved. If you have any questions in SSRS, you can feel free to let me know.

0 Votes 0 ·