title: Unable to connect remotely to SQL Azure DB using SSMS 2016
body: <p>I am able to connect to SQL Azure database using sql authentication . However, I am unable to connect using domain account(domain\AccountName) from Azure VM. I am using SSMS 2016 version and using the option 'Active Directory Integrated' and default database as the azure database.</p>
  
  <p>Few things to keep in mind
  1) I have created this Azure database in portal using the same account that I am testing now to connect from Azure VM.
  2)This domain account has MFA enabled because while connecting to VPN , I need to enter the password that I get over my phone to login</p>
  
  <p>Below are the errors that I am getting when trying to use each of the options</p>
  
  <p>1) Active Directory Integrated</p>
  
  <blockquote>
    <p>Cannot connect to XXXXX.database.windows.net.</p>
    
    <p>------------------------------ ADDITIONAL INFORMATION:</p>
    
    <p>Failed to authenticate the user NT Authority\Anonymous Logon in Active
    Directory (Authentication=ActiveDirectoryIntegrated). Error code
    0xCAA2000C; state 10 AADSTS50076: Due to a configuration change made
    by your administrator, or because you moved to a new location, you
    must use multi-factor authentication to access xxxxx. Trace ID:
    06d7d4bc-4fc2-4ce3-9bda-486e31370300 Correlation ID:
    ac7592ee-1c21-4875-8455-5a10a9588725 Timestamp: 2018-08-09 06:14:07Z
    (Microsoft SQL Server, Error: 0)</p>
  </blockquote>
  
  <p>2) Active Directory Password</p>
  
  <blockquote>
    <p>Cannot connect to xxx.database.windows.net.</p>
    
    <p>------------------------------ ADDITIONAL INFORMATION:</p>
    
    <p>Failed to authenticate the user User@domainname in Active
    Directory (Authentication=ActiveDirectoryPassword). Error code
    0xCAA2000C; state 10 AADSTS50076: Due to a configuration change made
    by your administrator, or because you moved to a new location, you
    must use multi-factor authentication to access
    xxxx. Trace ID:
    ac6347b5-c1f8-4f81-8f83-5284b8010400 Correlation ID:
    4e67f279-1d47-4ce9-97d7-68e074f616fc Timestamp: 2018-08-09 07:22:40Z
    (Microsoft SQL Server, Error: 0)</p>
  </blockquote>
  
  <p>3)Active Directory MFA</p>
  
  <blockquote>
    <p>Cannot connect to xxx.database.windows.net.</p>
    
    <p>------------------------------ ADDITIONAL INFORMATION:</p>
    
    <p>One or more errors occurred. (mscorlib)</p>
    
    <hr>
    
    <p>Unable to acquire authorization token
    (Microsoft.SqlServer.Management.AzureAuthenticationManagement)</p>
    
    <hr>
    
    <p>One or more errors occurred. (mscorlib)</p>
    
    <hr>
    
    <p>User canceled authentication
    (Microsoft.IdentityModel.Clients.ActiveDirectory)</p>
  </blockquote>