Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 change database owner

Author  Topic 

cezar
Starting Member

1 Post

Posted - 2006-01-20 : 21:03:11
Hello,
I am trying to change the database owner and when I run command
USE database
EXEC sp_changedbowner 'user'
GO
I get error message "Msg 15110, Level 16, State1, Line1
The proposed new database owner is already a user or aliased in the database."
I am running SQL 2005 on Windows 2003 with SP1 installed. I installed the application that creates the database and a user but doesn't make that user an owner the database.

Thanks in advance for any help.

Zvonimir

cshah1
Constraint Violating Yak Guru

347 Posts

Posted - 2006-01-21 : 16:39:33
'user' cannot become the owner of the current database if it already has access to the database through an
existing alias or user security account within the database. To avoid this, drop the alias or 'user' within the
current database first.
Go to Top of Page
   

- Advertisement -