CREATE DATABASE permission denied in database ‘master’. (Microsoft SQL Server, Error: 262)

I get CREATE DATABASE permission denied in database ‘master’ error when I try to create a new database in Windows Server.

This is what is going on:

When a user in the Administrators account runs SQL Server Management Studio, the User Account Control feature strips the membership token for that group and passes only the user account information to SQL Server. A message is returned that states that the account does not have rights to log in to SQL Server. To let members of the Windows Administrators group log in, you must explicitly add the account to the SQL Server logins.


To be more fair, this is the post that saved it for me :)

http://menononnet.wordpress.com/2011/03/07/create-database-permission-denied-in-database-master-microsoft-sql-server-error-262/