2

I have a SQL Server which I want to enable Azure AD authentication with. On the overview of the server, it shows Active Directory Admin as Not Configured. If I click on that, I am taken to this page:

enter image description here

I have blanked out my details, but you can see that I am unable to select my account. Why would this be?

1

but you can see that I am unable to select my account. Why would this be?

Currently, Microsoft accounts (like live.com, outlook.com) cannot be set as admin. Only users and security groups within your organization can be set as admin.

enter image description here

So, we should select other account to set as admin.

  • Nope, this is my company account with custom domain – George Edwards Aug 15 '17 at 7:44
  • @GeorgeEdwards Do you mean that account sync from your on-prem AD? – Jason Ye Aug 15 '17 at 7:51
  • No, it is all online, it has an associated office subscription etc. Microsoft Cloud services – George Edwards Aug 15 '17 at 7:52
  • @GeorgeEdwards Does that account can login Azure portal and read the resource group? – Jason Ye Aug 15 '17 at 7:54
  • Yes, it is the one currently logged in when I am looking at the SQL settings – George Edwards Aug 15 '17 at 7:55

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.