Timeline for PowerApps allow guest users to connect to Azure SQL database with AAD integrated feature
Current License: CC BY-SA 4.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 23, 2022 at 20:24 | answer | added | SeaDude | timeline score: 0 | |
| Jun 23, 2022 at 8:39 | answer | added | Rob Gauldie | timeline score: 0 | |
| S Mar 21, 2021 at 12:08 | history | bounty ended | Kresimir L. | ||
| S Mar 21, 2021 at 12:08 | history | notice removed | Kresimir L. | ||
| Mar 17, 2021 at 7:52 | answer | added | Tiny Wang | timeline score: 1 | |
| Mar 15, 2021 at 11:15 | comment | added | Kresimir L. | Hi @milivojeviCH, We've checked diagnostics on SQL, no query is even accessing the database. It looks like PA is unable to send requests when using AAD integrated guest account. We tried putting a guest in Security and Office365 groups, none is working. We tried giving the group and user all possible privilages that we can in Azure, still no luck. Now we wonder if it is even possible. so if anyone has succeeded in allowing guest users access from PowerApps to a SQL using AAD, it would be great if they could share how, or even acknowledge if it is possible, so that we know it is worth trying. | |
| Mar 14, 2021 at 21:30 | comment | added | milivojeviCH | What happens if you enable diagnostics on the Azure SQL Server and database level? From there, you could get an idea of why is something failing. In what kind of a group did you place those guests? What access level does that group have on the server/database? I have too many questions ;-) | |
| S Mar 14, 2021 at 10:24 | history | bounty started | Kresimir L. | ||
| S Mar 14, 2021 at 10:24 | history | notice added | Kresimir L. | Draw attention | |
| Mar 12, 2021 at 16:52 | comment | added | Kresimir L. | Nothing really, It still doesn't allow the communication between PA and SQL server, although no error messages occur ... | |
| Mar 12, 2021 at 9:43 | comment | added | Carl Zhao | What happens if you grant guest users the role of administrator? | |
| Mar 12, 2021 at 9:15 | history | asked | Kresimir L. | CC BY-SA 4.0 |