Ernani de São Thiago Ernani de São Thiago - 1 year ago 69
SQL Question

Azure SQL Server Can't create table

a couple weeks ago I acquired a SQL Server Database. And I start to develop my application with it with no problems since then.

Today, out of nowhere, I got this error:

Msg 262, Level 14, State 1, Line 1
CREATE TABLE permission denied in database 'master'.

This error is prompt everytime I try to create a table, I tried SELECT, it works fine. I'm trying to understand what is wrong for hours, I only have one user, which I created when I setup the database for the first time, and I checked it's permission, it shows that I have permission to create a new table.

Also, everytime I connect to it with Management Studio 2016, it asks for me to add my IP, so I know that's not the issue.

I really have no idea how to continue from here, everything I found online people talk about granting permissions which it doesn't seems to be what is happening here, since I checked my permissions.

Any other thoughts?

Answer Source

The error says,You don't have permission to create table in master database..try creating in your database..

You can't create table in master database in SQLAzure.Master database in SQLAzure is readonly and is there to hold information about roles,logins..

Check out this question as well:Please explain SQL Azure "master" database