HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMajor

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

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
thecreatepermissionunabledenieddatabasemasterget

Problem

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!

Solution

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'
GO


Or you Can/Should use

ALTER SERVER ROLE  [dbcreator]  ADD MEMBER [Shubhankar];
GO


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

Code Snippets

EXEC master..sp_addsrvrolemember @loginame = N'Shubhankar', @rolename = N'dbcreator'
GO
ALTER SERVER ROLE  [dbcreator]  ADD MEMBER [Shubhankar];
GO

Context

StackExchange Database Administrators Q#78388, answer score: 31

Revisions (0)

No revisions yet.