Lesson Learned #85: The impact of having a proxy server when you are connecting with AAD

This post has been republished via RSS; it originally appeared at: Azure Database Support Blog articles.

Hello Team,

 

Today I worked in a very cool service request when our customer was not able to connect to Azure SQL Database using Azure Active Directory.

 

After multiple troubleshooting process followed we found that our customer has a proxy configuration in their Internet Options->Connections->Local Area Network LAN setting of their Web browser.

 

We found that the configuration script defined contains some restrictions to an important URL that Azure Active Directory needs to use to perform the validation of the user/password in all the methods that they have.

 

If you are using Azure Active Directory please, review that you have allowed the connections to this FQDN: (for more reference review this URL: https://docs.microsoft.com/en-us/azure/active-directory/hybrid/tshoot-connect-connectivity)

 

  • login.windows.net
  • login.microsoftonline.com

 

Enjoy!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.