Azure web app can't access azure DB Azure web app can't access azure DB azure azure

Azure web app can't access azure DB


The web app has this connection string set up in its 'Application Settings/Connection strings' section. I'have checked the wep app IS using this connection string:

This is not where you set your connection string for your ASP.net 5 application.

Open your the file appsettings.json, the first section should contain the following data

  "Data": {    "DefaultConnection": {      "ConnectionString": "Server=(localdb)\\mssqllocaldb;Database=aspnet5-WestEuroSODBAccess-96be0407-8bee-4c89-97e5-f6711136f106;Trusted_Connection=True;MultipleActiveResultSets=true"    }

Place your connection string in there. Similar to this

  "Data": {    "DefaultConnection": {      "ConnectionString": "Server=tcp:[MyServerName].database.windows.net,1433;Database=[MyDbName];User ID=[MyUserName]@[MyServerName];Password=[MyPassword];Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"    }

That will resolve the issue. I did not catch originally that you were setting this up as an ASP.net 5 application.

Additional information can be found here: http://docs.asp.net/en/latest/fundamentals/configuration.html