I have an azure mobile app created, and am about to setup Easy Table. I have followed each step and have created a connection string to a SQL database created before the mobile app. But when I initialized app to use Easy Table, I got the error message which is: "Missing SQL Server connection string". But I have already added a connection string before.
Get ADO.NET connection information (optional - SQL Database only) Navigate to the database blade in the Azure portal and, under Settings, select Connection strings. Review the complete ADO.NET connection string. Copy the ADO.NET connection string if you intend to use it.
Choose Add your client IP to add your current IP address to a new, server-level, firewall rule. This rule can open Port 1433 for a single IP address or for a range of IP addresses. You can also configure firewall settings by choosing Add a firewall rule.
Configure connection strings. In the Azure portal, search for and select App Services, and then select your app. In the app's left menu, select Configuration > Application settings. For ASP.NET and ASP.NET Core developers, setting connection strings in App Service are like setting them in <connectionStrings> in Web.
I had the same issue and tried many times and it failed each time. Until my last try which went ok. The only difference with before? Well, I kept the default connection string name whereas before I was customizing it...
Yes. Leave the default connection string name "MS_TableConnectionString" and it will work.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With