Post reply

Error while creating a Database

  • February 28, 2007 at 4:29 am

    #115995

    Hello, I am Vikram,

    I just started using SQL 2005 of late from one week to be precise, I am trying to create a database and i receive an error "CREATE DATABASE permission denied in database master"

    Can anyone help me please

    Thanks for your help

    Vikram

     

  • February 28, 2007 at 5:22 am

    #692268

    Just to check, are you trying to create a database using an account that is a member of the sys admins group? If not, that'll be your problem so you'll need to either use the sa account or, much better from a security point of view, create a new administrator account with a sensible password, disable the sa account and use your new account to create your database.

     

    Also, this should really be in the SQL2005 groups, not the 7.0 and 2000 (you'll probably get more responses if it's in the right section). Don't know if admins can shift a post to a different group?

  • February 28, 2007 at 6:24 am

    #692278

    HIi Vkram Amit ,

    Which account u r using for login sql serve or your login has SA (System Admin) rights for creating a database.

     

    Regards,

    Amit Gupta

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply