Problem with SQL Database

[Anonymous]

Hi Guys, my company has a SQL serve with some important datasources, I am having soem trouble when conecting to it, then I asked my IT department they said that this SQL Server is closed, you can only access with you are in the same network as the company, this is a rule company, I cant not change it.. So I ask if there is a way that I can connect to it?

[dinusc]

Hello @Anonymous, I would suggest to discuss this issue with your IT department. There could be various solutions here but your IT should be in the best position to suggest one.

[Anonymous]

Yeah I discussed with them but they answered me that PowerApps is based on Cloud so thats why I can't connect to the SQL that is blocked from connections outside the same network company o.o

So now I am in doubt how to solve this x.x

[mogulman]

I'm not understanding.  Were you able to connect to SQL Server using On-Premise Data Gateway?  If you can connect then you should be able to see data gateway from PowerApps.

[Anonymous]

I tried to connect on PowerApps here:

connect directly based on cloud

maybe gateway is my solution here?

[mogulman · Accepted solution]

You need to connect on-premise SQL Server to Data Gateway then use SQL Server.  You'll select the named Gateway.  The Gateway will show this once you have connected to on-premise SQL Server.

[Anonymous]

Ok I will try it tomorrow on my company..

Thanks!

[Anonymous]

OK I DID it, but Now i dont know what to do, I tried to connect on PowerApps using the GateWay and got a licence error, but my licence is Dynamics....

I cant extend my plan 2 to test also :C

[mogulman]

I have a Business 365 license that comes with PowerApps and for right now free use of the Gateway.  They just announced they plan to charge for the Gateway starting 2/1/2019.  You probably need to check with support if Dynamics includes use of Gateway.

I'm just using Gateway to develop app.  I find the use of the SQL Profiler VERY useful in figuring what PowerApps is doing and improving performance.  I plan to move to Azure SQL DB.  I can get by with Basic plan and don't want headache of managing server.