Login failure - SQL Server Forums

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

SQL Server 2008 Forums

SQL Server Administration (2008)

Author

Topic

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2012-12-17 : 17:47:10

Hi,

We have following setup:
Login name: abc\xxxxxx
User Name: dbo
default schema: dbo
database role member: db_owner

When user try to login get failure message. Cannot login. When I tried to give it datareader permission there is error: "cannot use the special principal 'dbo' (Microsoft SQL Error: 15405). Same setup is working with other databaes except one. Any help. This is SQL Server 2000 database migrated to 2008 r2, still have 2000 compatibility level. Other databaes are also in same format and working fine.

Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2012-12-17 : 21:21:31

It is not clear. Are you getting error when you try to give datareader permission or before that. user is already db_owner and there is no need to give permission.clarify so that people will help you.

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2012-12-18 : 20:33:30

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:[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'[/CODE]

=================================================
Hear the sledges with the bells - silver bells!
What a world of merriment their melody foretells!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources