Forum Discussion
Force a SQL Database to proxy/gateway connection policy with connection string?
I have a couple of SQL databases in Azure that are set to the Default connection policy. That is, they use the gateway proxies when the connection comes from outside of Azure and the redirect when the connection is within Azure.
I'd like to override this on a per-client basis. Is there a way, in the connection string or an option somehow in SSMS to force a particular mode? Specifically, I want to force the Gateway/Proxy for clients, while leaving the server in Default mode for everything else.
Below are some of the references to this topic.
https://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-settings?view=azuresql&tabs=azure-portal#change-the-connection-policy
https://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture?view=azuresql