Connect azure web site to on-premise database over site-to-site vpn

Question

my goal is to run an azure web site that accesses data from our local company database.

I followed a tutorial on the web to setup an azure virtual network and connect it via site-to-site vpn to our local company network. In the azure portal I can see that the connection is actually working and that data is received and transmitted.

What do I have to do make the azure web site connect to the database? Is it enough to enter a connection string in the web config? Is it meant to work this way, or is the site-to-site vpn only set up to access azure virtual machines from the company network.

Let me know if I should provide more details on the connection overall.

Thanks for you help in advance.

Best regards, Frank.

Answer 1

Azure Web Sites do not support the Azure Virtual Network (as of 8/22/2013); http://www.windowsazure.com/en-us/manage/services/web-sites/choose-web-app-service/

You will need to create a cloud service deployment instead if you would like to use Virtual Network and access the on-premises database. Once that is done and your firewall is properly configured, it is like you say just a connection string.