You’re offline. This is a read only version of the page.
294
Help - I'm going wrong trying to connect to an Azure SQL Database using Entra ID authentication in a new Azure directory. (This is part of a project to improve overall cyber security...) Here's what I've done:
I'm missing something somewhere along the line, or just misnaming the server perhaps - where am I going wrong, please?!
Hi @PRATHEEK
First thought is, do your other users have the necessary premium PowerApps licences (used to be 'Power Apps Per User' or 'Power Apps Per App' but they've changed them recently)?
Hi @JonathanGibbs ,
We made SQL connection using an account by making the account as "Entra Admin". We are facing issue if any other user is trying to access the same PowerApps. The SQL connection is failing to connect to the DB. Error Screenshot is attached. Please let us know if you know any solutions for this.
Hi @chiflado8
Yes, sorting out privileges worked
I found I had to do the following in SQL:
In Master database
CREATE LOGIN [xxx@yyy] FROM EXTERNAL PROVIDER
CREATE USER [xxx@yyy] FROM LOGIN [xxx@yyy]
In the database to be used
CREATE USER [xxx@yyy] FROM LOGIN [xxx@yyy]
ALTER ROLE db_datareader ADD MEMBER [xxx@yyy]
ALTER ROLE db_datawriter ADD MEMBER [xxx@yyy]
ALTER ROLE exec_access ADD MEMBER [xxx@yyy]
Your roles may be different, of course, but the point is you need to work in both Master and the db you want to give access to when using Azure SQL Database
Hello @JonathanGibbs, I have a similar issue (error message 'primaryRuntimeUrl is required') when trying to connect to our SQL Database. Were you able to solve your problem by giving the user read/write privileges? Thanks.
Answering myself - I think the problem is that newUser@newDomain does not have a read/write role for the database. When I assign the PowerApps licence to MicrosoftEntraAdmin instead (which has full admin rights over the database) and create an app as MicrosoftEntraAdmin, it works as expected.
Now just need to find how to assign newUser to the appropriate roles..
#1
Michael E. Gernaey
9
Super User 2025 Season 1
#2
bscarlavai33
5
Super User 2025 Season 1
#3
getsplash
2
Share
Report
All responses (
Answers (
