XP_LoginInfo, Trusted Domains, and Clusters

[msnews.microsoft.com]

Hi,

I have two instances SQL 2000 SP3a running on a Windows 2000 SP4 Cluster. We
have two domains with a trust relationship setup and working. I have an
application that uses XP_LOGININFO to acquire information it needs about
it's users.

When I run xp_logininfo on one of the SQL Instances on the cluster for a
name in the other domain, I get the Server: Msg 8198, Level 16, State 24,
Procedure xp_logininfo, Line 58 error. However, if I run xp_logininfo from
another non-clustered SQL Server on the same domain (still using a name from
the other domain), it works.

It appears that everything is working correctly from all servers except the
ones on the cluster. Has anyone seen this behavior? Thanks.

[Mike Epprecht (SQL MVP)]

Hi

Check the following Microsoft KB's:

838460
834124 (State 24: When the SQL Server engine queried the Windows operating
system to retrieve information about a Windows account name, access was
denied).

Are the SQL System accounts the same on clustered and non-clustered servers?

cheers
Mike

Post by msnews.microsoft.com
Hi,
I have two instances SQL 2000 SP3a running on a Windows 2000 SP4 Cluster. We
have two domains with a trust relationship setup and working. I have an
application that uses XP_LOGININFO to acquire information it needs about
it's users.
When I run xp_logininfo on one of the SQL Instances on the cluster for a
name in the other domain, I get the Server: Msg 8198, Level 16, State 24,
Procedure xp_logininfo, Line 58 error. However, if I run xp_logininfo from
another non-clustered SQL Server on the same domain (still using a name from
the other domain), it works.
It appears that everything is working correctly from all servers except the
ones on the cluster. Has anyone seen this behavior? Thanks.

[David Willow]

Thanks for the reply. I looked at both of these articles before. I have
not applied any hotfixes to SQL (only SP3a) and I thought the second one was
on the right track, but it doesn't seem to make sense. I'm using the same
SQL System account on all servers.

Other than the cluster, everything is the same on all the SQL Servers.

Post by Mike Epprecht (SQL MVP)
Hi
838460
834124 (State 24: When the SQL Server engine queried the Windows operating
system to retrieve information about a Windows account name, access was
denied).
Are the SQL System accounts the same on clustered and non-clustered servers?
cheers
Mike

Post by msnews.microsoft.com
Hi,
I have two instances SQL 2000 SP3a running on a Windows 2000 SP4 Cluster. We
have two domains with a trust relationship setup and working. I have an
application that uses XP_LOGININFO to acquire information it needs about
it's users.
When I run xp_logininfo on one of the SQL Instances on the cluster for a
name in the other domain, I get the Server: Msg 8198, Level 16, State 24,
Procedure xp_logininfo, Line 58 error. However, if I run xp_logininfo from
another non-clustered SQL Server on the same domain (still using a name from
the other domain), it works.
It appears that everything is working correctly from all servers except the
ones on the cluster. Has anyone seen this behavior? Thanks.