Unable to connect to Azure SQL database with AAD authentication

Anonymous
2021-09-09T17:41:01.183+00:00

Hi Team,

We are unable to connect to Azure SQL database and managed instance from one of our servers, below is the error

Revocation of SSL certificate failed

Whereas when we connect using SQL server authentication its working fine, can you please help us out

Azure SQL Database
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Alberto Morillo 33,251 Reputation points MVP
    2021-09-09T20:08:04.733+00:00

    Please refer to this article and its solution.

    Hope it helps.

    0 comments No comments

  2. Oury Ba-MSFT 17,156 Reputation points Microsoft Employee
    2021-09-10T16:53:51.337+00:00

    Hi @Anonymous Welcome to Microsoft Q&A and Thank you for posting your question

    Please check the steps below to fix the issue

    • To fix Server certificate revocation failed problems perform the following...
    • Type gpedit.msc and click OK.
    • Navigate to Computer Configuration / Administrative Templates / Windows Components / Internet Explorer / Internet Control Panel / Advanced Page.
    • Double-click Check for server certificate revocation.
    • Select Disabled and click OK.
    • Reboot the server. For the AAD MFA authentication issue, the recommendation is to check your firewall settings and whitelist login.microsoftonline.com from source machine.
      Also, please make sure you have the latest SSMS version installed (v18.9): Download SQL Server Management Studio (SSMS) - SQL Server Management Studio (SSMS) | Microsoft Learn.

    Hope that helps

    Regards,
    Oury