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..