{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 Emotional °昔 的问题《Connecting SQL Server (On-prem) to Powerapps》','https://www.manongdao.com/q-1029606.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I've created a SQL Server Express instance and setup a Data Gateway within powerapps.
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.
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.
Anyone have experience with connecting SQL Server 2017 Express to Powerapps or know anything about this error message?
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.
Hope this saves someone the hassle of going through MS support.