Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Azure easy table connection string missing

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.

like image 375
Mr.War Avatar asked Jan 28 '16 08:01

Mr.War


People also ask

How do I get Azure SQL database connection string?

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.

How do I enable Port 1433 on Azure?

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.

How do I change my connection string in Azure?

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.


2 Answers

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...

like image 155
François Avatar answered Sep 17 '22 14:09

François


Yes. Leave the default connection string name "MS_TableConnectionString" and it will work.

like image 41
Thando Toto Avatar answered Sep 17 '22 14:09

Thando Toto