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).
- Select the Windows Firewall from the Control Panel
- Click on “Advanced settings\Inbound Rules”
- Sort the rules by port and select port 80 for HTTP or port 443 for HTTPS
- 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
- Select the Windows Firewall from the Control Panel
- Click on “Advanced settings\Inbound Rules”
- Right click on “Inbound Rules” and select “New Rule”
- Choose “Port” and click “Next”
- Select “Specific local ports” and enter 80 or 443 and click “Next”
- Make sure that “Allow the connection” is checked and click “Next”
- Choose the appropriate entry under profile (Domain, Private, Public) and click “Next”
- 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