debugsqlMajor
CREATE DATABASE permission denied in database 'master'. unable to get the permission
Viewed 0 times
thecreatepermissionunabledenieddatabasemasterget
Problem
I am making a database in sql server and it shows an error that
I am using the administrator log in itself.
What i need to do?
Please suggest a fix!
"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
You can execute the following statement to make a user member of
Or you Can/Should use
Members 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'
GOOr you Can/Should use
ALTER SERVER ROLE [dbcreator] ADD MEMBER [Shubhankar];
GOMembers 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'
GOALTER SERVER ROLE [dbcreator] ADD MEMBER [Shubhankar];
GOContext
StackExchange Database Administrators Q#78388, answer score: 31
Revisions (0)
No revisions yet.