Hi,

I can see how to add a Free 20Mb SQL database to Windows Azure Mobile service. Can I create a free 20Mb SQL database for website use, I see it is detailed on the pricing page for websites, but I cannot see any option in the management portal in the websites section or the database section to create this / these 20Mb SQL databases.

Update: I can also see how to link to the DB created in the mobile service in the Linked Resources. So not a hinderance I guess, just not intuitive to me. 

I'm probably missing something simple :-(

Paul

• Edited by mrpaulb Friday, February 14, 2014 2:38 PM

Can you tell me how to add the free 20Mb website database if I have already created a website? I have an existing website but now need a database. I don't want to create a new website?

Ok so here is how i did it!

1. Create Mobile Service with a free 20MB database. I used North Europe
2. Create an application in Visual Studio (select host in Azure and ensure authentication is selected)
3. Publish your site and ask it to create a website in azure for you
4. When publishing your site, in the settings section, you can insert a DB connection string there. Ensure the site is created in the same region as the database else your site will be slower and you will be charged for bandwidth (i found this out in azure when playing around with creating a mobile service and database)
5. Go into azure and select your database then "show connection strings"
6. Copy the string, put your password in and paste into visual studio before publishing.
7. Test it and it should work. If it doesn't, in Azure, you can add a firewall rule in the same window you copied the db connection string from.
8. Publish your site
9. In Azure, go to your website then select linked services and ensure ONLY your free database is in there. I found it sometimes creates a GB database. You don't want that in there as it charges you as you populate it.
10. Then again in your website area, go to "Configure" and scroll down to connection strings
11. Paste your conn string in there as well as a key value. The key being the conn string name in visual studio web.config and the value being the conn string
12. Thats all I did and it works.

http://digitalquarter.azurewebsites.net/

• Edited by Andrew Osiname Thursday, January 22, 2015 9:48 PM