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:




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


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.


1 Like