Forum Discussion

kfrazie1's avatar
kfrazie1
Icon for Helper I rankHelper I
6 years ago

On-premises data gateway - Network Request Returned Unexpected Error

Background: I'm running a PowerApps application and connecting to a 2014, 32bit sql server via an on premises datagateway on a virtual machine running windows server 2016. I had the gateway up and ru...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

What part of

 

 

EnterpriseGatewayConfigurator.exe Information: 0 : Value SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client is not defined in registry

 

 

is unclear ? 🙂

 

The gateway configuration requirements keep changing. Recommend to re-read the documentation.

 

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-tshoot 

 

If it's any consolation - it took me three weeks and several tickets to get my gateways back up after the "June Desaster".

kfrazie1's avatar
kfrazie1
Icon for Helper I rankHelper I
6 years ago

Hi,

 

It's not clear to me. Could you provide a little more information on TLS? Do I need to adjust a registry setting? I upgraded to the latest version of .Net (4.8). Could this be part of the issue?

 

Thx

 

Keith

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

    You need to patch the registry on your gateway machine to set TLS1.2 to not disabled.

     

    Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2]

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client]
"DisabledByDefault"=dword:00000000

     

     

    • kfrazie1's avatar
      kfrazie1
      Icon for Helper I rankHelper I
      6 years ago

      I dont have TLS 1.2. The only folder under Protocol is SSL 2.0. Should I be creating TLS 1.2?

       

      Thx

       

      Keith

      • kfrazie1's avatar
        kfrazie1
        Icon for Helper I rankHelper I
        6 years ago

        I added TLS 1.2 to the registry. Also added DisabledByDefault and set to 0. Added Enabled and set to 1. Restarted the Virtual Machine, re-installed the Gateway, and still got a few errors.