Can't create a new Database on my desktop
I'm getting message
CREATE DATABASE permission denied in database 'master'
CREATE DATABASE permission denied in database 'master'
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?
How are you connecting, with SQL or integrated auth?
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.
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.
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.
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.
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.
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.
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.
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.
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.
"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.
ASKER
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?
The LocalDB doesn't come with SSMS but with SQL Server setup media.
ASKER
Thanks but what you mean by 'SQL Server setup media'
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Well done!
Right click on the Databases and then choose create database ..