Azure Active Directory non-admin user access Azure SQL database

0
votes

I need to create several users in Azure active directory and allow them to access my Azure SQL DB. What I do is create them here

enter image description here And then I create them in database

CREATE USER [[email protected]] FROM EXTERNAL PROVIDER;
ALTER ROLE db_datareader ADD MEMBER [[email protected]];

But after I login, it triggers the browser-based authentication and then I get the following error

enter image description here

However, it works awesome with the AD account that set as Active Directory Admin

enter image description here

I am using SSMS and 'Azure Active Directory - Universal with MFA' authentication mechanizm

1
azureazure-active-directoryazure-sql-database
Which Authentication Protocol are you using to connect? Windows Authentication won't work. – David Browne - Microsoft
I am using Azure Active Directory - Universal with MFA – vily
And does that trigger the browser-based authentication flow for you? – David Browne - Microsoft
Expand the "Options" of the connection dialog, and on the second tab you can specify the database name to connect directly to the database. – David Browne - Microsoft
Worked! You are the man – vily

1 Answers

0
votes

Answer: in this case, you don't have permissions to connect to the server so you should specify the database when you log in