<div>
Master is already a DB. What exactly are you doing???<br />
<br />
Right click on the Databases and then choose create database ..<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/12_w50/1215076/EE.jpg" target="_blank" title="EE.jpg (61 KB)"><img alt="EE.jpg" class="file-block lazyload" style="max-width: 387px;" data-src="https://filedb.experts-exchange.com/incoming/2017/12_w50/1215076/EE.jpg" /></a>
</div>


EE.jpg

<div>
That error will show if you're logged in as a user that doesn't have dbcreator or sysadmin roles.<br />
How are you connecting, with SQL or integrated auth?
</div>


<div>
The <b>master</b> database normally manages system data.<br />
<br />
Follow Pawan's example to create a database.<br />
<br />
If you still get this message, when creating any new database, likely your specific user requires some additional privilege to create databases.<br />
<br />
In this case, you'd visit with your admin about fixing this for you.
</div>


<div>
Please see-<br />
<br />
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. &nbsp;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.
</div>


<div>
No, you simply need &quot;dbcreator&quot; or &quot;sysadmin&quot; server roles.<br />
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.<br />
Just the server roles.<br />
<br />
dbo is not sufficient or required to create a new database.
</div>


<div>
The CREATE DATABASE permission is set on the <b>master</b> database and that's why the error message.<br />
Since you don't have a <b>sysadmin</b> 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.
</div>


<div>
you just need to get &nbsp;&quot;right' sql server permissions -- &gt;&nbsp;if you are DBA on this box &nbsp;&quot;sa role' permission will cover it&quot;<br />
<br />
&quot;Create a Database&quot;<br />
<a href="https://docs.microsoft.com/en-us/sql/relational-databases/databases/create-a-database" rel="ugc">https://docs.microsoft.com/en-us/sql/relational-databases/databases/create-a-database</a><br />
&quot;Permissions: Requires CREATE DATABASE permission in the master database, or requires CREATE ANY DATABASE, or ALTER ANY DATABASE permission.<br />
To maintain control over disk use on an instance of SQL Server, permission to create databases is typically limited to a few login accounts.
</div>


<div>
I redownloaded and installed SSMS 2014 just to make sure I start fresh. I could not find any LocalDB &quot;server&quot; that I can use for practice. &nbsp;I thought LocalDB as a server instance is provided by default on install?
</div>


<div>
The LocalDB doesn't come with SSMS but with SQL Server setup media.
</div>


<div>
Thanks but what you mean by 'SQL Server setup media'
</div>


<div>
<div class="content wysiwyg-content">
I'm getting &nbsp;message<br />
CREATE DATABASE permission denied in database 'master'
</div>
</div>


I'm getting  message
CREATE DATABASE permission denied in database 'master'

Can't create a new Database on my desktop

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.