Forum Discussion
kfrazie1
Helper I
Helper IOn-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...
kfrazie1Helper I
Helper IHi,
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
Super User
Super UserYou 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
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
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.
- kfrazie1
EnterpriseGatewayConfigurator.exe Information: 0 : Starting EnterpriseGatewayConfigurator, Version 3000.51.7 EnterpriseGatewayConfigurator.exe Information: 0 : Initialize EnterpriseGatewayMainViewModel EnterpriseGatewayConfigurator.exe Information: 0 : GetConfiguratorStateAsync EnterpriseGatewayConfigurator.exe Information: 0 : Value SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1\Client is not defined in registry. EnterpriseGatewayConfigurator.exe Information: 0 : Value SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1\Client is not defined in registry. EnterpriseGatewayConfigurator.exe Information: 0 : Found SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client/Enabled data in registry, value: 1. EnterpriseGatewayConfigurator.exe Information: 0 : Found SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client/DisabledByDefault data in registry, value: 0. EnterpriseGatewayConfigurator.exe Information: 0 : Value SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client is not defined in registry. EnterpriseGatewayConfigurator.exe Information: 0 : Value SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client is not defined in registry. EnterpriseGatewayConfigurator.exe Information: 0 : Found SOFTWARE\Microsoft\.NETFramework\v4.0.30319/SchUseStrongCrypto data in registry, value: 1. EnterpriseGatewayConfigurator.exe Information: 0 : Found SOFTWARE\WOW6432Node\Microsoft\.NETFramework\v4.0.30319/SchUseStrongCrypto data in registry, value: 1. EnterpriseGatewayConfigurator.exe Information: 0 : Configuration client returned null EnterpriseGatewayConfigurator.exe Information: 0 : Sign In EnterpriseGatewayConfigurator.exe Error: 0 : Exception: Microsoft.PowerBI.DataMovement.GatewayCommon.EmailDiscoveryServiceException: Network request returned unexpected error. ---> System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 20.42.6.2:443 at System.Net.Sockets.Socket.InternalEndConnect(IAsyncResult asyncResult) at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception) --- End of inner exception stack trace --- at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult, TransportContext& context) at System.Net.Http.HttpClientHandler.GetRequestStreamCallback(IAsyncResult ar) --- End of inner exception stack trace --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.DataMovement.GatewayCommon.ConfiguratorClientExtensions.<DiscoverEmailProperties>d__8.MoveNext() --- End of inner exception stack trace --- at Microsoft.PowerBI.DataMovement.GatewayCommon.ServiceEnvironmentDetailsFactory.GetEnvironment(String emailAddress, Uri endpoint, String preferredCloud) at Microsoft.PowerBI.DataMovement.GatewayUiCommon.WizardSignInViewModel.StartSignIn(IServiceEnvironmentDetailsFactory serviceEnvironmentDetailsFactory, ConfiguratorAzureGeo selectedGeo) at Microsoft.PowerBI.DataMovement.GatewayUiCommon.WizardSignInViewModel.DoNext(Object param) at Microsoft.PowerBI.DataMovement.GatewayUiCommon.WizardViewModelBase.DoNextWorker(Object param) at Microsoft.PowerBI.DataMovement.GatewayUiCommon.RelayCommand.<>c__DisplayClass19_0.<Execute>b__0() EnterpriseGatewayConfigurator.exe Information: 0 : Update checks EnterpriseGatewayConfigurator.exe Information: 0 : Create web request for Uri: http://www.msftncsi.com/ncsi.txt EnterpriseGatewayConfigurator.exe Information: 0 : Response status: OK EnterpriseGatewayConfigurator.exe Information: 0 : Create httpClient request for Uri: http://www.msftncsi.com/ncsi.txt EnterpriseGatewayConfigurator.exe Information: 0 : Response status: OK EnterpriseGatewayConfigurator.exe Information: 0 : Checking for PbiEgwService EnterpriseGatewayConfigurator.exe Information: 0 : Fetch state for PbiEgwService EnterpriseGatewayConfigurator.exe Information: 0 : Service state: Running EnterpriseGatewayConfigurator.exe Information: 0 : Create httpclient request for Uri: http://www.msftncsi.com/ncsi.txt EnterpriseGatewayConfigurator.exe Information: 0 : Response status: OK EnterpriseGatewayConfigurator.exe Information: 0 : Value SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1\Client is not defined in registry. EnterpriseGatewayConfigurator.exe Information: 0 : Value SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1\Client is not defined in registry. EnterpriseGatewayConfigurator.exe Information: 0 : Found SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client/Enabled data in registry, value: 1. EnterpriseGatewayConfigurator.exe Information: 0 : Found SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client/DisabledByDefault data in registry, value: 0. EnterpriseGatewayConfigurator.exe Information: 0 : Value SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client is not defined in registry. EnterpriseGatewayConfigurator.exe Information: 0 : Value SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client is not defined in registry. EnterpriseGatewayConfigurator.exe Information: 0 : Found SOFTWARE\Microsoft\.NETFramework\v4.0.30319/SchUseStrongCrypto data in registry, value: 1. EnterpriseGatewayConfigurator.exe Information: 0 : Found SOFTWARE\WOW6432Node\Microsoft\.NETFramework\v4.0.30319/SchUseStrongCrypto data in registry, value: 1.