Azure SQL Database
An Azure relational database service.
5,444 questions
Please refer to this article and its solution.
Hope it helps.
Unable to connect to Azure SQL database with AAD authentication
![](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(128, 8%, 22%)' 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)
Anonymous
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
2 answers
Sort by: Most helpful
-
-
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee2021-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-
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee
2021-09-13T15:41:45.493+00:00 Hi @Anonymous Did you had the chance to check the steps above to troubleshoot this issue. The article shared by @Alberto Morillo is also helpful. Please let me know if it worked.
Regards,
Oury -
Anonymous
2021-09-13T18:10:10.447+00:00 This is working but will this setting cause any security issue? Can you give more details on this setting?
Thanks,
jJanaki -
Anonymous
2021-09-14T11:42:13.29+00:00 This is working only for one set of azure database with naming convention 'sdb' other azure databases issue is still there. But this time below is the error
-
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee
2021-09-20T23:08:51.037+00:00 @Anonymous Could you please open a support ticket so we can better troubleshoot this issue. Please share the ticket number so we can keep track of your case.
https://learn.microsoft.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-requestLet me know if you run into any issues.
Regards,
Oury -
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee
2021-09-29T22:51:18.777+00:00 @Anonymous Checking if you were able to create a support ticket. Let us know if you don't have a support plan?
Regards,
Oury
Sign in to comment