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.
| Author |
Topic |
|
mmcnary
Starting Member
16 Posts |
 Posted - 2011-08-11 : 13:25:44
|
| In some SQL Server instances, when I run xp_logininfo <group>, 'members' I get the expected results, but in others I receive the following error:Msg 15404, Level 16, State 4, Line 42Could not obtain information about Windows NT group/user <Domain group>, error code 0x52e.This error pops on both sql2005 and sql2008, and works on both as well. I have a very mixed environment.Are there any special settings or permissions that need to be set in an instance to allow this sp to run? Naturally, the instance in which I am developing is one where the statement works, so I didn't find the error until I deployed it to the rest of the DEV tier.Thanx, -Mark McNary |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mmcnary
Starting Member
16 Posts |
Posted - 2011-08-11 : 15:21:30
|
| Thanx for the quick response, Tara.I guess I should have put more handles on the issue. I have a stored procedure that enumerates the various privileges granted in the instance. I am spinning through syslogins, and pulling a list of logins identified as 'AD Group'. I then go through the list of groups and use xp_logininfo to get the list of members, which are then documented as each having the privileges granted to the AD group.Thanx, -Mark McNary |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-11 : 15:33:59
|
| Seems likely that you're misidentifying some of your logins as AD Groups.Also, have a look at this |
|
|
|
mmcnary
Starting Member
16 Posts |
Posted - 2011-08-15 : 08:35:24
|
| This is the failing sql statements from xp_logininfo select 'account name' = domain+N'\'+name, 'type' = convert(varchar(8), case when sidtype = 1 then 'user' else 'group' end), 'privilege' = @priv, 'mapped login name' = domain+N'\'+name, 'permission path' = @acctname from OpenRowset(NetGroupGetMembers, @acctname) order by 3, 1Thanx, -Mark McNary |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-15 : 08:39:58
|
| SELECT name FROM sys.server_principals WHERE type = 'G' |
|
|
|
mmcnary
Starting Member
16 Posts |
|
|
|
|
|
|
|
xp_logininfo works inconsistently