#domain #dns(w2k3 - nt4) logininfo
-
Does anyone know why sqlserver(2ksp3 on W2ksp4 with AD-on W2003-server) cannot get to an nt4-domain-info ?
I've created this windows-group (GRPDevelopersOtherDomain) on my domain. To this group I've added user-id's of an other trusted NT4-domain, to be able to have these users managed by our helpdesk.
I've granted this windows-group (MYDOMAIN\GRPDevelopersOtherDomain) login to my sql2k instance(virtual) and to some databases.
All the sql-instances run using windows-accounts.
When I login as sysadm and I want to show members, it gives this error :
EXEC master..xp_logininfo @acctname = 'MYDOMAIN\GRPDevelopersOtherDomain',@option = 'members'
Server: Msg 8198, Level 16, State 12, Procedure xp_logininfo, Line 38
Could not obtain information about Windows NT group/user 'MYDOMAIN\GRPDevelopersOtherDomain'.
EXEC master..xp_logininfo @acctname = 'MYDOMAIN\GRPDevelopers',@option = 'members'
memberlist is shown
EXEC master..xp_logininfo @acctname = 'REMOTEDOMAIN\user1'
(0 row(s) affected)
Server: Msg 8198, Level 16, State 24, Procedure xp_logininfo, Line 58
Could not obtain information about Windows NT group/user 'REMOTEDOMAIN\user1' .
I've found BUG: Xp_logininfo Returns Error 8198 (233161) (http://support.microsoft.com/default.aspx?scid=kb;EN-US;233161), but those conditions are not met.
Another thing is that when I look at 'MYDOMAIN\GRPDevelopersOtherDomain' using EM \Security\logins I get to see it's a windows group and it's been granted.
When I look at the group in a databases userlist, it says database access "via group membership". (I've added that group to the db-users using EM\Security\logins and checked the db with db_datareader group)
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Might be the issue described at http://support.microsoft.com/default.aspx?scid=kb;en;241643. Forwarded it to my Windows administrators.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply