Can't create a new Database on my desktop

I'm getting  message
CREATE DATABASE permission denied in database 'master'
zachvaldezAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook 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
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
zachvaldezAuthor Commented:
Well done!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.