March 9, 2007 at 11:12 am
I must be missing something in permissions. We have a Domain Acct and Login named "Able". Able has a server role of sysadmin. When I am connected using this account and create a new database, I cannot get the dbo to be Able. When I try, I get an error message that says that Able is already a User in the database.
Dbo defaults to sa which is not what I want.
Strange thing is, a few of the database on this server are owned by Able and the dbo role is also owned by Able. So I know it can be done, I just don't know how to get there.
TIA
Elliott
March 9, 2007 at 12:56 pm
how are you changing the database owner ?
* Noel
March 9, 2007 at 1:12 pm
Noel,
I am creating a new database using EM and trying to select my WindowsGroup
Login ("Able") as the database owner. I receive the error message that "the proposed new db owner 'Able' is mapped as user 'Able' in this database"
This is blowing my mind because the database doesn't even exist yet on the server, yet the user is already mapped to it.
Elliott
March 9, 2007 at 2:07 pm
Hey Elliot,
After you create the database, you could run something similar from a query window in that database's context.
exec
sp_revokedbaccess 'Able'
go
exec
sp_changedbowner 'Domain\Able'
go
-Dan B
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply