Post reply

CREATE DATABASE permission denied in database ''master''. (.Net SqlClient Data Provider)

  • February 14, 2007 at 9:48 pm

    #175082

    CREATE DATABASE permission denied in database 'master'. (.Net SqlClient Data Provider)

    Server name: WINXP_HOME\SQLEXPRESS

    CONNECTION: WINXP_HOME\leonel

    can someone give steps by steps how to fix this problem,

  • February 15, 2007 at 8:26 am

    #689974

    What permission does the login have?

    CREATE DATABASE permission defaults to members of the sysadmin and dbcreator fixed server roles.

    -SQLBill

  • February 16, 2007 at 5:11 pm

    #690348

    when I check Logins under Security, this is what i see:

    Builtin\user

    sa

    IF i Create new login i can not do it because, user not allow to perform this action, error 15247

     

  • February 19, 2007 at 9:23 am

    #690511

    Most likely the account you use to create a login is membe of the Builtin\User group in windows xp and it is not a member of sysadmin or dbcreators fixed server role.  Use sa account to create a new login.

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

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