In the SQL Azure management console when administering a Server you have an option to set the "allowed ip addresses" and also "allowed services". Within "allowed services" you can allow WINDOWS AZURE SERVICES but what does this mean exactly? Specifically, does this mean anyone else running a VM on Azure can connect to my server (assuming they know the username & password)? Or is there some other restriction like only azure services running within the same Subscription can connect, or only Linked Resources?
Sign in to the Azure portal. Search for and select SQL servers, and then select your server. Under Security, select Networking. Under the Public access tab, ensure Public network access is set to Select networks, otherwise the Virtual networks settings are hidden.
In the Azure portal, select SQL databases from the left-hand menu, and select your database on the SQL databases page. In the Security section, select Transparent data encryption. If necessary, set Data encryption to ON. Select Save.
"WINDOWS AZURE SERVICES" means exactly what you suspect - anyone running any kind of service in Windows Azure (Azure WebSites, Azure Cloud Services/web/worker roles, Azure Virtual Machines) can access your SQL Database. But in order to really connect to your database, one must know all of:
Linked resources are only for visually help you organize all resources around a single application and some other light stuff.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With