After publishing the web API to Azure in Visual Studio, and adding two SQL databases in the wizard the account database connected itself without problems to the app service in azure. The data containing database, however, did not. How do I tell the app service web API to use that database?
Add a comment
|
2 Answers
Depending on how your solution was created, you will have a "web.config" and/or an "app.config" file.
Open these up and check the "connectionStrings" section. You should have an entry for each database connection. Verify that these are pointing to the proper databases with the proper security.
In Web.config, the "connectionStrings" section is in the section "configuration". In "App.config the connectionStrings section is in the same place.
1 Comment
user19440
Thank you for your answer. I checked and it actually only contains the connection string from the local databases i was running. Interestingly somehow one of the databases for the accounts is working and interacting with the app service without me specifying anything. Why does this not apply to the database containing the application data.
You will have to allow certain IP addresses to connect to it. Look at the SQL Database server's Firewall setting. You can the IP address of your computer (or IP range), to access SQL Database
Make sure to enable Allow Azure services and resources to access the server
