CREATE DATABASE permission denied in database ‘master’.


  • Hi,

    I have tipical situation in my database environment. i have task for deployment few object in Stage environment while running those scripts showing these error message "create database permission denied in database 'master'"

    I have SA permissions in my server and environment is Sql server 2008 r2.

    Please help on this.

    thanks in advance


    Friday, August 15, 2014 3:19 PM


All replies

  • If you have SA permissions then you will never get this error.

    What is the login that you used. Confirm if you indeed has SA permissions in the instance that you are trying to execute the script and got this error.

    Regards, Ashwin Menon My Blog - http:\\

    Friday, August 15, 2014 3:30 PM
  • thanks for your reply,

    I have given SA permission for this user id, even through i got this error. 


    Vijay bhaskar

    Friday, August 15, 2014 7:29 PM
  • Did you logoff and on again after it was granted?

    A sysadmin user cannot be restricted from anything.  That right overrides all over security.

    Friday, August 15, 2014 7:41 PM
  • I found the resolution for this issue. It's required Login (windows Login) not user to execute these kind of powershell scripts.

    thanks everyone helping me on this issue.


    Monday, August 25, 2014 6:58 PM