This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 80%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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!
@Alex Thank you for posting your question on Microsoft Q&A forum and for using Azure services.
From my understanding, you are trying to access Azure SQL database through SSMS AAD MFA.
Could you please share the error message you are getting while trying to connect to the DB through SSMS?
Regards,
Oury
@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
@Alex
Just checking in if you have had a chance to see the previous response.
Please comment in the below section if you need further help in this matter!
Thanks Oury,
I'll give this a go now,
Regards,
Alex
@Alex Checking if you are still facing the same issue.
Regards,
Oury