2

According to the first note on this Microsoft Azure article: Connecting to SQL Server running on an Azure VM is not supported using an Azure Active Directory account. Use a domain Active Directory account instead.

Now, I'm using the free Azure trial account for Azure databases and would like to test the scenario of connecting to a Azure SQL Server database on an Azure VM. Which domain Active Directory account should I be using for this test?

nam
  • 217
  • 1
  • 11

1 Answers1

2

I test in my lab, I could login on SQL server with Azure AD authentication. The user name is ADSQLAdmin@<your AD>.onmicrosoft.com, like below:

enter image description here

Shui shengbao
  • 3,503
  • 1
  • 10
  • 20
  • After I opened the LabVM, I changed the password for ADSQLAdmin. Then I went to LabVM (that was already opened) and filled in the info (similar to the ones your screenshot is showing) into the SSMS 2016. But when I entered the new password, it says `Cannot open server "...hotmail.onmicrosoft.com" requested by the login. The login failed.` I think it probably has something to the fact that I changed the password. Any ideas? – nam Nov 24 '17 at 00:58
  • Your user is `@hotmail.onmicrosoft.com`? – Shui shengbao Nov 24 '17 at 01:08
  • Hi, we could chat in this room https://chat.stackexchange.com/rooms/69147/discussion-between-shengbao-shui-msft-and-nam – Shui shengbao Nov 24 '17 at 01:09
  • 1
    It's working now. Thank you again for coming to my rescue and pointing out that I was using wrong Authentication. I was using SQL Server Authentication instead of what you show in your screen shot above. – nam Nov 24 '17 at 01:37
  • Now I'm unable to connect to the SQL Server using ADSQLUser account. Any suggestions? I've posted the details [here](https://serverfault.com/q/884938/425441). – nam Nov 24 '17 at 02:25
  • OK, I am checking it. – Shui shengbao Nov 24 '17 at 02:27
  • We could chat here https://chat.stackexchange.com/rooms/69147/discussion-between-shengbao-shui-msft-and-nam – Shui shengbao Nov 24 '17 at 02:34