Good afternoon everyone. I'm having trouble creating a database. Since I get the error
CREATE DATABASE permission denied in database 'master'
Since the SuperUser (sa) I have given permission to the user "Lucas" with db_owner so he can create databases but still the error persists.
I hope you can help me, greetings.
Solved. I need to mark it as sysadmin in Server Roles.
Following the recommended practice of not giving more access than necessary, if the user only needs to be able to create new databases, you can give the server role dbcreator .
As commented @jachguate, you also do not need to assign db_owner of the database master . So, if you can avoid this too, it's a good idea.
If you give the server role sysadmin , it also works of course, but you will also be giving access to the database server entirely.
Choose the server role that is most appropriate for you.