SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

Peter99
Constraint Violating Yak Guru

494 Posts

Posted - 12/17/2012 :  17:47:10  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
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

USA
1782 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:
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!

Edited by - Bustaz Kool on 12/19/2012 19:00:38
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.03 seconds. Powered By: Snitz Forums 2000