I can't connect my Azure database server to SMSS 18

Alex 1 Reputation point
2022-03-11T16:42:35.36+00:00

I've set up my Azure account, set the admin and changed the firewall settings to accept my IP address but I still can;t connect to SMSS. When i connect to server in SMSS I'm using Azure Active Directory - - Universal with MFA. It was working yesterday and now it isn't. I deleted the Azure database and made a new one but still no dice - any help would be much appreciated!

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Oury Ba-MSFT 16,886 Reputation points Microsoft Employee
    2022-03-11T22:57:26.893+00:00

    @Alex I was able to verify that SSMS 18 AAD Universal auth should work for MFA with conditional access policies enabled. The issue may be related to your ADFS or network.

    https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-configure

    Regards,
    Oury