You cannot map a Login to the special database User "dbo". It is already mapped to the "sa" login. Go to one of the databases where this is working and run this code:select
sp.Name LoginName, dp.name UserName
from
sys.server_principals sp
inner join
sys.database_principals dp
on dp.sid = sp.sid
where
dp.name = 'dbo'
=================================================
Hear the sledges with the bells - silver bells!
What a world of merriment their melody foretells!
Login failure
Posted - 12/17/2012 : 17:47:10
