"Cannot connect to the remote server" when connecting through a call to the .NET ReportingService web service

Question

I have report services running on SQL Server 2008 within a domain. I can hit http: // localhost / reportserver without errors. I can get to the same site from the website (also in the domain name) using the internal IP address of the DB block (192.169.XX / ReportServer / ReportService.asmx.) I looked at the SSRS logs and I see these images correctly recorded, no errors.

However .. I have a website that uses the .NET ReportingService class to connect to SSRS. Using the same credentials as before, I get "Unable to connect to the remote server."

I checked there is no firewall. Quadrupled checked the configuration on the website to make sure it had the correct credentials and service URL for SSRS. There are no hits in SSRS logs either when I try to connect via .NET, so something is definitely blocking access.

I swallowed my fingers in blood and seriously wanted to help. I'm sure this is a small thing, I just can't think about it.

Answer 1

Perhaps your reporting services are open only to private ip and your localhost. Try setting the static ip address of your domain for configuration. I added the SSRS Url configuration link for a quick link.

Answer 2

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

Answer 3

The following worked for me: I removed SSL and set it to 0 versus 2 in the path G: \ Program Files \ Microsoft SQL Server \ MSRS11.MSSQLSERVER \ Reporting Services \ ReportServer - the reportserver.config file.

Basically, it was preconfigured with SSL on port 443, but the server was moved to another domain and did not know where to go in order to get a new SSL certificate for this domain, so I deleted the SSL configuration in the graphical interface of the Reporting Services configuration, and then deleted its also in the reportserver.config file.

Answer 4

Make sure your report URL ends with / Reportserver / (for the purpose of invoking .NET code). Also keep in mind that you must use the full URL. It should include the server name and domain.

Check this link

Answer 5

For me, the following change has changed:

• Delete SSL configuration

  1.1. Reporting Services Configuration Manager

  1,2. Web service URL (click the Advanced button, and then remove the SSL configuration);

  1.3. Report Manager URL (click the Advanced button, and then remove the SSL configuration);

• Edit the rsreportserver.config file, usually in the path C: \ Program Files \ Microsoft SQL Server \ MSRS11.MSSQLSERVER \ Reporting Services \ ReportServer \

  2.1. find out the SecureConnectionLevel key;

  2.2. change the key value from "2" to "0";