Msg 262, Level 14, State 1, Line 1 CREATE DATABASE permission denied in database 'mas

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • venuvasavi
    New Member
    • Jan 2012
    • 13

    Msg 262, Level 14, State 1, Line 1 CREATE DATABASE permission denied in database 'mas

    Hi,

    When i am running my query through sqlcmd, occurs this error
    "Msg 262, Level 14, State 1, Line 1
    CREATE DATABASE permission denied in database 'master'."


    Thanks in Advance
    VAsavivenu
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    That means you don't have permission to create a database. Talk to your administrators and see if they can/will give you that permission

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32633

      #3
      It also means you're trying to create a database in Master instead of the database you should be working in. I suggest you look at your SQL and make sure it goes nowhere near the Master database before you go anywhere near an Admin. I doubt they'll be too amused if they see that.

      Comment

      • venuvasavi
        New Member
        • Jan 2012
        • 13

        #4
        Thank for your response,
        I got the solution from sql server area configuration, by adding the administrator. But I need to do this through sqlcmd.

        Thanks in Advance
        Vasavivenu

        Comment

        Working...