Azure How To Problems And Fixes

HOW TO

Database First Design Project which you can Deploy To Azure  Guide

https://www.asp.net/mvc/overview/getting-started/database-first-development/setting-up-database

 

--------------------

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.