Reputation: 6794
What is the best way to create a secure connection to SQL Azure from a customer location?
We are currently using IP address and setting the firewall, but this is not very secure
Upvotes: 1
Views: 131
Reputation: 5496
That's pretty much all you have with the Azure SQL Database offering today. The TDS protocol is sent to the client over TLS so the transport is secured.
Note that you could theoretically create a "jump" or "bastion" host in Azure on a VM, and allow only connections to Azure SQL from the public VIP of that host, but I'd question how much more secure that is than what you have now.
Upvotes: 2