Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
First of all, Thank you for reading this question.
My datasource is just two.
One is an Oracle Database and the other is an Excel file in sharepoint.
My Gateway on server is working well with DB connection.
(Our companys secure level is high, because of that, I was already open firewall port)
However, When Gateway connect the sharepoint, error message is coming.
[ The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ]
before that, I used sharepoint without gateway and db conncetion with gateway both. that's working well.
but this time, I have to using gateway both because merging two datasources.
I think it's firewall issue, so if you know firewall about sharepoint domain&port let me kwow please.
my already opened domain&port are below
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-communication
I tried open the *.sharepoint.com 80/443. but it also not working.
Hi, @mabum777
The gateway communicates with Service Bus by using an IP address along with a fully qualified domain name (FQDN). If you force the gateway to communicate via HTTPS, it will strictly use FQDNs only and won't communicate by using IP addresses.
You may run the network ports test, it retrieves a list of ports and servers from Service Bus and then attempts to connect to all of them. The test results list all the servers, ports, and IP addresses that your gateway requires. If the test results display "Closed" for any ports as shown in the following screenshot, ensure that your network environment didn't block those connections. You might need to contact your network admin to open the required ports.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reply,
I already did network port test, all Test results are success.
Gateway work very well now, but only sharepoint datasource is not working.