none
CREATE DATABASE permission denied in database ‘master’.

    Question

  • 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

    Vijay


    Friday, August 15, 2014 3:19 PM

Answers

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:\\sqllearnings.com

    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. 

    thanks

    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.

    Vijay

    Monday, August 25, 2014 6:58 PM