Post reply

Cannot alter the user 'dbo'

  • April 29, 2009 at 9:59 am

    #204074

    I logged into sql as myself: domain\myusername.

    I have sysadmin access to the server.

    I created a database with its default owner.

    When I looked at my logins name and see if the new database

    i created has my login on it, it has dbo instead.

    I tried to change dbo to my login and it gave me this error above:

    Msg 15150, Level 16, State 1, Line 2

    Cannot alter the user 'dbo'.

    I've been googled this issue and none of the discussion suggestion worked.

    including sp_changedbowner. Some other discussion is too lengthy and it went

    right over my head.

    How can I changed the dbo user to my login? any advice would be appreciated.

  • April 29, 2009 at 10:12 am

    #986093

    What you're seeing is perfectly normal. A login that's a member of the sysadmin group does not automatically get a user created in each database, rather they are 'mapped' to the dbo user (database owner)

    There's nothing wrong with what you're seeing and there's nothing that needs changing

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 29, 2009 at 10:22 am

    #986103

    I see. Thanks much Gail. I usually see the user login on it, so that

    is why I thought it is strange that it says 'dbo'.

  • December 27, 2011 at 9:19 am

    #1425758

    I have the opposite problem. I have a user and I want to to be dbo. sqlserver 2008 R2

    The user is in the administrator's group in localmachine\username.

    I want this user to be able to connect to databases. I have defined the user as public and sysadmin.

  • December 27, 2011 at 9:34 am

    #1425769

    Carolyn S. White (12/27/2011)

    I have the opposite problem. I have a user and I want to to be dbo. sqlserver 2008 R2

    The user is in the administrator's group in localmachine\username.

    I want this user to be able to connect to databases. I have defined the user as public and sysadmin.

    Please start another thread for your question / problem. It helps us keep two or more scenarios (& their responses) separate from each other.

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

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