0

So I have a C# client app UI. The UI needs to retrieve some data from Azure SQL. My Azure SQL has an Azure Active Directory Admin set/enabled.

The users who use the UI all should have access to Azure SQL (i.e. log in to SQL Server Management Studio) via Active Directory Integrated/MFA authentication.

I would like to the authentication experience be seamless. However, prompting/challenging the user with a login prompt would be just fine as well.

The problem is that when I run the UI, i get prompted for my login. I provide my id/email address, and if I provide them in a certain way, i get the MFA process going (i get a phone call to authenticate myself). However, upon getting authenticated, i see an immediate prompt that says the app "...needs permission to access resources in your organization that only an admin can grant. Please ask an admin to grant permission to this app before you can use it."

Note that I am essentially following this article.

Questions:

Is it possible to avoid this process which requires an Admin to approve?

Would it be acceptable for the UI itself to send an approval request (using the AAD Admin set under Azure SQL)?

Improve this question
5
  • did you use the AD admin account to access the database, which database did you access? AD account like sql login, if you are not using admin account, you must grant the account permission to access the database. Commented Sep 22, 2020 at 7:00
  • Thanks Leon. I will try logging in using the sql admin account. But, isn't there a way to make this work? After all, I am able to login using my personal org account when i connect to the same database via SQL Server Management Studio. Commented Sep 22, 2020 at 17:22
  • Wondering if this is a better alternative? stackoverflow.com/questions/51707764/… Commented Sep 22, 2020 at 20:48
  • Please let us know have you given admin consent? Commented Sep 24, 2020 at 11:12
  • Are you still looking for any help with this question? Commented Sep 28, 2020 at 14:16
Related questions
0
Connecting to SQL Azure database from client applications
2
Acquiring Azure AD Token for Azure SQL Server
2
Using Active Directory Authentication for Azure SQL server in .Net Core App 1.1
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.