将 SQL Server(本地)连接到 Powerapps [英] Connecting SQL Server (On-prem) to Powerapps

问题描述

我已经创建了一个 SQL Server Express 实例并在 powerapps 中设置了一个数据网关.

I've created a SQL Server Express instance and setup a Data Gateway within powerapps.

网关在 SQL Server 对话框窗口中正确显示，但当我添加凭据时，它会暂停一分钟，然后返回 DMTS_EncryptClusterCredentialsErrorCode 错误消息.

The Gateway appears properly in the SQL Server dialog window, but when I add the credentials it pauses for a minute then returns a DMTS_EncryptClusterCredentialsErrorCode error message.

在与服务器管理员一起查看了大约 1 小时后，我们无法弄清楚问题是什么.我们启用了 TCP/IP 并且能够从我们的桌面正确连接到有问题的数据库，所以这应该不是数据库设置的问题.

After looking at this with a Server Admin for ~1 hour we were unable to figure out what the issue is. We have TCP/IP enabled and are able to connect to the Database in question properly from our desktops, so it shouldn't be an issue with the db setup.

任何人都有将 SQL Server 2017 Express 连接到 Powerapps 的经验或了解有关此错误消息的任何信息?

Anyone have experience with connecting SQL Server 2017 Express to Powerapps or know anything about this error message?

推荐答案

我最终就这个问题向 MS 提交了一张票，在与代表合作了一段时间后，它归结为切换 https 开关.

I ended up submitting a ticket to MS regarding this issue and after working with the rep for a while, it came down to toggling the https switch.

希望这可以为某人省去通过 MS 支持的麻烦.

Hope this saves someone the hassle of going through MS support.

这篇关于将 SQL Server(本地)连接到 Powerapps的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！