CREATE DATABASE permission denied in database 'master'. unable to get the permission

  • I am making a database in sql server and it shows an error that "CREATE DATABASE permission denied in database 'master'" I am using the administrator log in itself. What i need to do? Please suggest a fix!

    This is the screenshot and the error message i used to get when i create a database in sql server 2008

    Do you use the Windows admin login or the SQL Server admin? If the former, it doesn't neccessarily mean that the Windows admin is a SQL Server admin automatically. Can you try it using the sa account?

  • M.Ali

    M.Ali Correct answer

    6 years ago

    The user must be a member of dbcreator server role for user to have enough permissions to create a database.

    You can execute the following statement to make a user member of dbcreator server role.

    EXEC master..sp_addsrvrolemember @loginame = N'Shubhankar', @rolename = N'dbcreator'

    Members of sysadmin role are by default members of dbcreator server role therefore they can create databases too.

    User does not have permission to perform this action.

    @Hill then you need to ask your DBA to add your in the correct Server Role.

    `sp_addsrvrolemember` is in maintenance mode and should not be used anymore, rather user `alter server role`, e.g. `alter server role dbcreator add member domain\user.

  • To create database you need sysadmin role permission for the user. Go to Database-> Security -> Logins section in object explorer and edit the properties of the user that you want to have create permission. In the Server Roles section you can find sysadmin. Tick it and save the user. Now you will have access to create database.

    For Reference :

  • All the above points are clear but there is one which is missing. I struggled to find the solution to this problem and finally got it after long research.

    To get permission to create database in your local account follow the below given steps.

    Step 1: Disconnect from your local account.

    Step 2: Again Connect to Server with Login : sa and Password : pwd(pwd given to your local login).

    Step 3: Object Explorer -> Security -> Logins -> Right click on your server name -> Properties -> Server Roles -> sysadmin -> OK

    Step 4: Disconnect and connect to your local login and create database.

    Successfully created the database :D ;)

  • I was having same problem, I noticed I was connected using Windows Authentication. I then disconnected and used SQL Server Authentication. It started good.

License under CC-BY-SA with attribution

Content dated before 6/26/2020 9:53 AM