Azure SQL server: How to tell if the client is inside or outside Azure

Question

Hi,

I came across this documentation about Connection Policy to Azure SQL servers https://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture?view=azuresql#connection-policy . There are 3 different methods: Redirect, Proxy, Default. And in Default, connections will be Redirect if client is within Azure and Proxy if client is outside Azure

So can someone explain how the SQL server knows which connections are from within Azure and which connections are from outside Azure? What mechanism they use to check that?

Answer 1

Hello Duc Le Trung,

Thanks for your question.

Broadly, It relies on the client’s IP address to determine if the connection originates from within Azure or from an external source. See:

https://www.microsoft.com/en-us/download/details.aspx?id=56519

Regards,

You can mark it 'Accept Answer' if this helped.