cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
senthilkan
Level: Power Up

Can PowerApps application connect to Azure SQL Database Managed Instance

Can PowerApps application connect to Azure SQL Database Managed Instance?

 

I have exisiting PowerApps application that connects to SQL database hosted in Azure VM server.  Planning to move Database to new Azure SQL Database Managed Instance.  I am reading through this link [https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-connect-app] for different type of connections from Client Applications. PowerApps connectivity is not mentioned. Any pointers would be helpful.

1 REPLY 1
Highlighted
Super User
Super User

Re: Can PowerApps application connect to Azure SQL Database Managed Instance

I have not tried doing it with a managed instance, but I have done a SQL Connector to a regular Azure SQL database (SAAS not IAAS). If you look at the properties of the SQL Instance you should see a server name.  Use that in the regular SQL connector with the database name and it should work. Note: you will need to have setup the managed instance with a proxy to the Internet.  Otherwise it won't be reachable.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
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

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 111 members 4,864 guests
Please welcome our newest community members: