as

Friday, 17 January 2014

SQL Server Express CREATE DATABASE permission denied in database 'master'

You might get below  error in sql server 2005/2008/2012.
SQL Server Express CREATE DATABASE permission denied in database 'master'

To fix this error follow below steps.
  1. From start menu go to -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.
  2. Then you will see one link "Add New Administrator"
  3. Select 'Member of SQL Server SysAdmin role on SQLEXPRESS' and add it as a new administrator.
  4. Now restart your sql server management studio.


What do you think on this topic? Please express your opinion through comment below

Sponsored Links

Popular Posts

Comments

ShareThis