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