SQLTeam.com | Weblogs | Forums

Permission denied when creating a database

I have SQL Server 2019 and SSMS 18 installed.

When I try to create a database, I get the following error:

 Msg 262, Level 14, State 1, Line 1

    CREATE DATABASE permission denied in database 'master'

I tried several guides to mitigate this:

codeproject..com/Questions/5280021/CREATE-DATABASE-permission-denied-in-database-mast

sqlshack..com/how-to-use-sql-server-configuration-manager/

ibm..com/docs/en/sgfmw/5.3.1?topic=setup-adding-users-setting-permissions-sql-database

But I keep getting an error that I cannot change to sysadmin or dbcreator.

image

Seems as if your login doesn't have the sysadmin role, nor the db creator role.
If you have a DBA Database Administrator or even a System Admin, they may be able to grant your login the dbcreator server role.

image

1 Like