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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Login failure
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Constraint Violating Yak Guru

498 Posts

Posted - 12/17/2012 :  17:47:10  Show Profile  Reply with Quote

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.


Flowing Fount of Yak Knowledge

7174 Posts

Posted - 12/17/2012 :  21:21:31  Show Profile  Reply with Quote
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.
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

1834 Posts

Posted - 12/18/2012 :  20:33:30  Show Profile  Reply with Quote
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:
   sp.Name LoginName, UserName
   sys.server_principals sp
inner join
   sys.database_principals dp
      on dp.sid = sp.sid
where = 'dbo'

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

Edited by - Bustaz Kool on 12/19/2012 19:00:38
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000