locked
"CREATE DATABASE permission denied in database 'master'. " RRS feed

  • Question

  • no database is creating in SQL .erroe is DATABASE CANNOT BE CREATED IN MASTER. THOUGH I CHOOSE ANOTHER DATABASE.
    Thursday, March 15, 2012 6:26 PM

Answers

  • What version of SQL Server?

    If you are using SQL 2005 on Win7/Windows 2008 or R2

    Right click on SQL Server management Studio and Choose "Run as Administrator"

    If you are using SQL 2008/R2, make sure your user account (account under you are logged into windows) has appropriate permission to creaet new database. By default in SQL 2008/R2 Windows admins are not given sysadmin permission in SQL server unless othewise done during the setup process.

    refer to Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out

    http://msdn.microsoft.com/en-us/library/dd207004.aspx


    • Edited by Chirag Shah Thursday, March 15, 2012 6:52 PM
    • Proposed as answer by Iric Wen Tuesday, March 20, 2012 5:51 AM
    • Marked as answer by Iric Wen Friday, March 23, 2012 9:11 AM
    Thursday, March 15, 2012 6:33 PM

All replies

  • What version of SQL Server?

    If you are using SQL 2005 on Win7/Windows 2008 or R2

    Right click on SQL Server management Studio and Choose "Run as Administrator"

    If you are using SQL 2008/R2, make sure your user account (account under you are logged into windows) has appropriate permission to creaet new database. By default in SQL 2008/R2 Windows admins are not given sysadmin permission in SQL server unless othewise done during the setup process.

    refer to Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out

    http://msdn.microsoft.com/en-us/library/dd207004.aspx


    • Edited by Chirag Shah Thursday, March 15, 2012 6:52 PM
    • Proposed as answer by Iric Wen Tuesday, March 20, 2012 5:51 AM
    • Marked as answer by Iric Wen Friday, March 23, 2012 9:11 AM
    Thursday, March 15, 2012 6:33 PM
  • Hello,

    Are you trying to create a new database in Master database? or if your o.s is not xp then you need to run the ssms as administrator

    Saturday, March 17, 2012 8:44 AM