HOW TO
--------------------
PROBLEMS AND FIXES
Azure Mobile Service
Problem
HTTP RESONSE ERROR ON GET data, before database is created
Fix
below is an invalid name due to . charecter
<add key="MS_MobileServiceName" value="ProximityShoppingApp.Service" />
The below is the succesful working change
<add key="MS_MobileServiceName" value="ProximityShoppingAppService" />
Problem
Cannot connect to Azure Database Server Via SQL MANAGEMENT STUDIO
Cannot publish database to Azure Database Server.
Fix
Company Service Desk (i.e SMSMT) might be blocking ip address in firewall, so will not be able to connect to it.
go into command prompt
type nslookup 'http://put database server address here"
this will tell the database servers ip address.
then tell service desk to allow access to it via the firewall.