PowerApps slow performance after disable TLS 1.0 registry key on On-premises data gateway server

[cpan]

We are disabling the TLS 1.0 on the On-premises data gateway server. Once we disable the TLS 1.0 registry on Windows server, the PowerApps performance becomes extremely slow.  Below is the setup:

On-Premises data gateway server

Windows 2016

On-Premises data gateway version: 3000.21.22 (December 2019 (Release 2))

Registry Keys:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319]"SchUseStrongCrypto"=dword:00000001 [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v4.0.30319]"SchUseStrongCrypto"=dword:00000001

As soon as we disable the TLS 1.0 in registry, it slows down the PowerApps performance. Below is the registry to disable TLS 1.0

            reg add "HKLM\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client" /v Enabled /t REG_DWORD /d 0 /f

            reg add "HKLM\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client" /v DisabledByDefault /t REG_DWORD /d 0 /f

            reg add "HKLM\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Server" /v Enabled /t REG_DWORD /d 0 /f

            reg add "HKLM\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Server" /v DisabledByDefault /t REG_DWORD /d 0 /f

Is there additional setup needs to be done on the gateway server?

[v-siky-msft]

@cpan 

I suggest you submit a support ticket to Microsoft for further assistance.

https://admin.powerplatform.microsoft.com/support 

Sik

[cpan · Accepted solution]

We are able to solve the issue by installed the latest "Microsoft SQL Management Studio" along with the "On-premises data gateway" service. It appears a driver from Management Studio is needed to solve the slow PowerApps performance issue after disabled the TLS 1.0/1.1.

[joppewal]

My experience here was similar.  TLS 1.0/1.1 was disabled on our internal SQL server. After that happened Power Apps performance when calling data from SQL was severely degraded.

Per this article, I installed the latest version of SSMS on the gateway server, restarted the gateway service, and performance was instantly restored.

Thanks!