cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Problem with SQL Database

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?
1 ACCEPTED SOLUTION

Accepted Solutions
mogulman
Level 8

Re: Problem with SQL Database

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.

 

DataGateway.png

 

 

 

8 REPLIES 8
Microsoft Employee

Re: Problem with SQL Database

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
Not applicable

Re: Problem with SQL Database

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
Level 8

Re: Problem with SQL Database

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
Not applicable

Re: Problem with SQL Database

I tried to connect on PowerApps here:

 

connect directly based on cloud

 

Capturar.PNG

maybe gateway is my solution here?

mogulman
Level 8

Re: Problem with SQL Database

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.

 

DataGateway.png

 

 

 

Anonymous
Not applicable

Re: Problem with SQL Database

Ok I will try it tomorrow on my company..

Thanks!

Anonymous
Not applicable

Re: Problem with SQL Database

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
Level 8

Re: Problem with SQL Database

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. 

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Top Community Contributors for September  2019

Top Community Contributors for September 2019 🎉🎉

Let's thank our top community contributors

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 452 members 5,501 guests
Please welcome our newest community members: