web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / On premise SQL Gateway...
Power Apps
Unanswered

On premise SQL Gateway won’t connect

(0) ShareShare
ReportReport
Posted on by 56

I have per app licenses for my users so we can connect to an Azure SQL database, which works fine. I am now attempting to connect the same app to an on premise SQL Database through a gateway which I have set up. I see the gateway in power apps when attempting to make the connection, however after filling in the connection information I receive and error stating I don’t have the correct License.  Under the user setting PLANS, it’s lists Power apps for office 365.   I understand this license will not work, that’s why I have a per app license.  Not sure what to do, the licenses are applied to the correct environment and the auto assign per app passes setting is set to yes. Any ideas?  Thank you. 

Categories:
I have the same question (0)
  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @long ,

     

    Would you like to use on-prem data gateway with Power Apps Per App Plan?

     

    As per the error message, please make sure that an app with Power Apps Per App Plan has been shared with you and then you will be able to create premium connection.

     

    You could ask to share the app with you again, and then retry to create a connection with the gateway.

     

    If this issue persists, you could raise a support ticket on support page:

    https://powerapps.microsoft.com/en-us/support/

     

    Hope this helps.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @long ,

     

    Have you resolved the issue? 

    If my post helps, then please consider Accept it as the solution to help the other members find it.


    Best regards,
    Community Support Team _ Jeffer Ni

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 577

#2
WarrenBelz Profile Picture

WarrenBelz 440 Most Valuable Professional

#3
Haque Profile Picture

Haque 308

Last 30 days Overall leaderboard