• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 46
  • Last Modified:

Can't create a new Database on my desktop

I'm getting  message
CREATE DATABASE permission denied in database 'master'
0
zachvaldez
Asked:
zachvaldez
  • 3
  • 3
  • 2
  • +3
1 Solution
 
Pawan KumarDatabase ExpertCommented:
Master is already a DB. What exactly are you doing???

Right click on the Databases and then choose create database ..

EE.jpg
1
 
Snarf0001Commented:
That error will show if you're logged in as a user that doesn't have dbcreator or sysadmin roles.
How are you connecting, with SQL or integrated auth?
0
 
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
The master database normally manages system data.

Follow Pawan's example to create a database.

If you still get this message, when creating any new database, likely your specific user requires some additional privilege to create databases.

In this case, you'd visit with your admin about fixing this for you.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Pawan KumarDatabase ExpertCommented:
Please see-

Only the dbo or a user with dbo rights is allowed to create new databases. You must be logged on with a user that has rights on the master database.  Otherwise it is not possible to make changes to the master database. And also, when you create a new database that information is stored in the master database, so you must have at least some kind of INSERT rights to the master.
0
 
Snarf0001Commented:
No, you simply need "dbcreator" or "sysadmin" server roles.
The master db acts a fair bit differently than user databases, you don't need to manually add the user to the master users list, or give any insert permissions.
Just the server roles.

dbo is not sufficient or required to create a new database.
1
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
The CREATE DATABASE permission is set on the master database and that's why the error message.
Since you don't have a sysadmin role in the SQL Server instance you'll need to ask a DBA to create the database for you or ask the DBA to grant you the CREATE DATABASE permission.
0
 
Eugene ZCommented:
you just need to get  "right' sql server permissions -- > if you are DBA on this box  "sa role' permission will cover it"

"Create a Database"
https://docs.microsoft.com/en-us/sql/relational-databases/databases/create-a-database
"Permissions: Requires CREATE DATABASE permission in the master database, or requires CREATE ANY DATABASE, or ALTER ANY DATABASE permission.
To maintain control over disk use on an instance of SQL Server, permission to create databases is typically limited to a few login accounts.
0
 
zachvaldezAuthor Commented:
I redownloaded and installed SSMS 2014 just to make sure I start fresh. I could not find any LocalDB "server" that I can use for practice.  I thought LocalDB as a server instance is provided by default on install?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
The LocalDB doesn't come with SSMS but with SQL Server setup media.
1
 
zachvaldezAuthor Commented:
Thanks but what you mean by 'SQL Server setup media'
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
LocalDB is only available with SQL Server Express Edition. Is this Edition that you have?
If affirmative then follow this instructions.
1
 
zachvaldezAuthor Commented:
Well done!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 3
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now