CREATE DATABASE PERMISSION DENIED IN DATABASE ‘master’

I have installed SQL SERVER 2008  on my system with Windows 7 operating system installed.
Whenever I try to create a new database it displays an error:
CREATE DATABASE PERMISSION DENIED IN DATABASE 'master'.(Microsoft SQL Server, Error:262).

After a lot of search i am found a solution.

When i start SQL server management studio use ‘sa’ user and not Windows-User. Looks like Windows-user does not have permission.

First, open SQl in administrator mode.
In Security node ,open logins and select users node. In server role tab, tick sysadmin and User Map tab tick master database and select owner in below section.

Click Ok in all windows. Close SQL Management Studio and open it in normal mode.
Now i can create database. No Issues..

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s