You might get below error in sql server 2005/2008/2012.
SQL Server Express CREATE DATABASE permission denied in database 'master'
What do you think on this topic? Please express your opinion through comment below
SQL Server Express CREATE DATABASE permission denied in database 'master'
To fix this error follow below steps.
- From start menu go to -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.
- Then you will see one link "Add New Administrator"
- Select 'Member of SQL Server SysAdmin role on SQLEXPRESS' and add it as a new administrator.
- Now restart your sql server management studio.