Home > Knowledge Base Articles > Fail to connect to reporting services

Fail to connect to reporting services

This article applies to the following products:

     Messageware Exchange Protocol Guard 2019

     Messageware Exchange Protocol Guard 2016

     Messageware Exchange Protocol Guard 2013

 

 

SYMPTOM

When launching the Messageware EPG Reports the error “failed to connect to reporting services at http://<server name>reportserver. Unable to connect to the remote server” may appear.

 

 

This could happen if port 80 or 443 are blocked on the firewall on the SQL server hosting the EPG database and EPG reports.

 

SOLUTION

There are two possible solutions to resolve this, first confirm that there is an inbound rule for port 80 for HTTP or 443 for HTTPS in the SQL server and it is enabled. We recommend only 443 for HTTPS (SSL).

 

  1. Select the Windows Firewall from the Control Panel
  2. Click on “Advanced settings\Inbound Rules”
  3. Sort the rules by port and select port 80 for HTTP or 443 for HTTPS
  4. Confirm that the rule is enabled and “Allow the connection” is checked

 

Figure 1- Port 80 rule

Second, create an inbound rule to allow connections on ports 80 for HTTP and 443 for HTTPS

  1. Select the Windows Firewall from the Control Panel
  2. Click on “Advanced settings\Inbound Rules”
  3. Right click on “Inbound Rules” and select “New Rule”
  4. Choose “Port” and click “Next”
  5. Select “Specific local ports” and enter 80 or 443 and click “Next”
  6. Make sure that “Allow the connection” is checked and click “Next”
  7. Choose the appropriate entry under profile (Domain, Private, Public) and click “Next”
  8. Enter a rule name and click “Finish”

 

NOTE

To use port 443 for HTTPS an SSL certificate will be needed.

If you do not have an SSL certificate for this server you can create a self-signed certificate.

Please refer to the link below for additional information

 

https://kb.messageware.com/266159-How-to-enable-HTTPS-communication-to-SQL-Reporting-Services