Announcements
Hi allHas anyone been able to successfully access an Azure SQL database using the SQL server connector through service principal authentication? I have not had success connecting to the Azure resource hosting the Azure SQL database. The documentation does not cover this form of authentication
I would like to know what permissions the service principal will require (API and SQL database) and anything else required to authenticate this way.Thanks in advance
@RT-PK
Were you able to get this working ?
I am too trying to use service principal authentication and always see the error 'Resource not found'
Also I don't see any option to enter DB instance details other than TenantId/ClientId/Secret.
Thanks
Ragh
@raghuml I was not able to get this working. I made sure the service principal had access to:1. Azure resource group (SQL Database)
2. Azure SQL server API permissions
3. Azure SQL role permissionsIf anyone else has had any success with this, I would like to know.
Same for me
6/14/23. Still same error "The tables didn't load correctly. Please try again. Resource not found". Anyone else able to access the Sql Db using Service Principal Authentication?
Hi all,
Just FYI, we did not go ahead with this solution as it is still intrinsic which have many security concerns. As the secure intrinsic feature is still in preview, we will be unable to use that for our solution
Did anyone figure this out? I can't figure out where or how to pass server and db parameters.
I have been stuck at this for the past few days.
Very frustrating there is not much documentation about service principal authentication method in power apps sql connector.
I finally found this:
https://learn.microsoft.com/en-us/connectors/sql/#general-known-issues-and-limitations
Which says in very fine print:
"Only Azure Logic Apps supports using a service principal to connect to SQL Server."
Tried using the sql connector from a logic app and it works perfectly fine. But inside a power app - doesn't work.
Nice, thanks for the link!
Hi - I'm having similar issue while connecting to Azure SQL MI database from PowerApps. I'm able to connect to database using same service principal ID from ADF but for powerapps I'm getting the gateway timeout error.
This now working, seems like microsoft worked on the authentication. But it is still autheticating individual user when shared. 😞
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 483
WarrenBelz 399 Most Valuable Professional
11manish 327
