CODEWITHSUNDEEP
databaseazureweblocal
Frank
Frank

Reputation: 55

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

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.

Upvotes: 3

Views: 5109

Answers (2)

Kirk Liemohn
Kirk Liemohn

Reputation: 7933

I am currently looking into connecting Azure Web Sites to an on-prem SQL database using the Azure Service Bus:

Upvotes: 0

Bart Czernicki
Bart Czernicki

Reputation: 3683

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.

Upvotes: 3

Related Questions