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?
Solved! Go to 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.
I suggest you submit a support ticket to Microsoft for further assistance.
https://admin.powerplatform.microsoft.com/support
Sik
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.
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!
User | Count |
---|---|
256 | |
114 | |
95 | |
48 | |
40 |