CODEWITHSUNDEEP
node.jsazurexamarin.forms
learnerDev94
learnerDev94

Reputation: 1

Unable to create the 'TodoItem' Easy table in Azure Portal

I've been following this tutorial on how to create a backend service for my xamarin application: https://learn.microsoft.com/en-us/azure/app-service-mobile/app-service-mobile-xamarin-forms-get-started

I have managed to create the Web App Service and have connected it to my Azure SQL database and have successfully initialized the Easy Tables function for my service.

However, when I try to create the TodoItem table, I receive the following error message:

Table creation error :

There was an error while creating table 'TodoItem'. '{"Code":"InternalServerError","Message":"{\r\n \"Message\": \"An error has occurred.\",\r\n \"ExceptionMessage\": \"CREATE TABLE permission denied in database 'master'.\",\r\n \"ExceptionType\":

I'm not sure as to why I'm receiving this error, and I'd appreciate any help.

Upvotes: 0

Views: 158

Answers (2)

Adam Marczak
Adam Marczak

Reputation: 2351

Your app seems to be connected to master.

CREATE TABLE permission denied in database 'master'

Add database name to connection string. 

Server=myServerAddress;Database=myDataBase;User Id=myUsername;

Upvotes: 1

logeshpalani31
logeshpalani31

Reputation: 1638

Edit your Azure SQL DB create permission for this app service.

Upvotes: 0

Related Questions