cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cpan
Helper I
Helper I

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
cpan
Helper I
Helper I

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.

View solution in original post

3 REPLIES 3
v-siky-msft
Community Support
Community Support

@cpan 

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

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

Sik

cpan
Helper I
Helper I

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!

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,028)