SQL Server on premises data gateway persistently showing error "The Gateway Is Either Offline Or Could Not Be Reached"

(0) Share

Report

Posted on by techdeveloper

Hi,

I've develop a few forms to support business transaction in my company. I'm using my company internal server with Windows Server 2012 R2 and Microsoft SQL server 2014 for the data source and connect it via on-premises data gateway. At first it runs smoothly but suddenly 3/4 days ago it started showing error "The Gateway Is Either Offline Or Could Not Be Reached" when our staff and i tried to access it, but strangely it happen at random, sometimes it run smooth but sometimes it show that error, but it's persistent.

I've tried to update the on-premises data gateway apps to the latest version, updated pending update on windows server, but still doesn't fix the problem.

Can anyone here help me figure out what cause this problem ?.

Thank you.

Categories:

Authentication

All responses (1)

Answers (0)

techdeveloper 19 on at

Like (0)

Report

Re: SQL Server on premises data gateway persistently showing error "The Gateway Is Either Offline Or Could Not Be Reached"

thank you, I appreciate it.

I've tried disable HTTPS Mode from the gateway apps and add modified register key in our server as in this documentation :
Adjust communication settings for the on-premises data gateway | Microsoft Docs

Now the error has lessen, and I think it's started to get normal again.