Windows Azure Mobile Services - Error: Table 'sometable' does not exist. - 404

Windows Azure Mobile Services provides a JavaScript client library that can be used to perform CRUD operations using HTML and JavaScript in a HTML5 web app.

There is a Mobile Services quickstart project to manage a TODO list that you can download from the Windows Azure portal. If you wish to create a custom table for a similar app, you have to first provide a table name within Windows Azure portal and set a permission level against each operation for the table (as shown in the diagram below).

click to enlarge image

Instead of doing this, if you directly create a table via the SQL Server Management Studio or the Silverlight-based Azure SQL Database portal, you will encounter the error Table 'sometable' does not exist. - 404 when you try to access this table using a script. 

To resolve this issue after you've created the table, you can go to the Mobile Services section in the Azure portal, select the Data tab and click on the Create option at the bottom. Give the table the same name as the one you've created outside the Portal and you should then be able to overcome the error.