Forum Discussion

BrianVallelunga's avatar
BrianVallelunga
Copper Contributor
Apr 04, 2024

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

No RepliesBe the first to reply

Resources