Cannot alter the user 'dbo'

Question

Cannot alter the user 'dbo'

sqlblue

SSCrazy

Points: 2324
More actions
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.

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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

sqlblue SSCrazy Points: 2324 More actions · Answer 2

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'.

Carolyn S. White SSC Enthusiast Points: 118 More actions · Answer 3

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.

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 4

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.