Unable to create Azure Mobile Service: Error 500

Question

I can't create a mobile Service in Azure: I receive that there's an error at calling the location information for mobile services: Error 500:

Fehler beim Abrufen der Standortinformationen für mobile Services: Fehler 500. Wiederholen Sie den Vorgang. Sollte das Problem weiterhin bestehen, wenden Sie sich an den Support.

Note that its not an error 400 as in the similar question Unable to create Azure Mobile Service.

Answer 1

I had to go into my existing azure sql database server and under the configuration tab select "yes" to allow azure services to access the server.

Note: this is the configuration for the server not the database.

Once I did this, I tried again to create my mobile service and it worked.

Answer 2

Perhaps I can provide additional information:

I got this error message as well, along with the "Error 500" mentioned above:

{"message":"Please try again. If the problem persists, contact support.","ErrorMessage":"Please try again. If the problem persists, contact support.","httpStatusCode":"InternalServerError","operationTrackingId":"","stackTrace":null,"Padding":null}

For this, the only thing that worked for me was creating a brand new SQL database with 20MB on a new server and using the username & password I chose when I created that server.