Unanswered

SQL Server connector - Service principal authentication

(0) Share

Report

Posted on by RT-PK

Hi all

Has 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

Annotation 2023-03-08 155030.png

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

All responses (11)

Answers (0)

anmolgan81 8 on at

Like (0)

Report

Re: SQL Server connector - Service principal authentication

You can still figure out this issue maybe some permission and access missing on the database, but you will get stuck when it comes to sharing the powerapp with service principle connection. Because its not shareable. Hence promoting the user to enter all those detail each time they open the page.
Vaishali04 7 on at

Like (0)

Report

Re: SQL Server connector - Service principal authentication

This now working, seems like microsoft worked on the authentication. But it is still autheticating individual user when shared. 😞
JHUser 6 on at

Like (0)

Report

Re: SQL Server connector - Service principal authentication

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.
Ifran_ 5 on at

Like (0)

Report

Re: SQL Server connector - Service principal authentication

Nice, thanks for the link!
Yashvit 8 on at

Like (3)

Report

Re: SQL Server connector - Service principal authentication

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.
Ifran_ 5 on at

Like (0)

Report

Re: SQL Server connector - Service principal authentication

Did anyone figure this out? I can't figure out where or how to pass server and db parameters.
RT-PK 4 on at

Like (0)

Report

Re: SQL Server connector - 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
Uk_pwrAppUser 2 on at

Like (0)

Report

Re: SQL Server connector - Service principal authentication

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?
alex9379992 7 on at

Like (0)

Report

Re: SQL Server connector - Service principal authentication

Same for me
RT-PK 4 on at

Like (0)

Report

Re: SQL Server connector - Service principal authentication

@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 permissions

If anyone else has had any success with this, I would like to know.