Joie Andrew (2/24/2010)

---

If it was authenticating against the domain that the server was a member of, then there is a preferred dc key that you can set in the registry...

I just talked to AD guys, one of the clue is: How SQL talks to AD to authenticate a valid user? is it possible to manually configure (hardcode it) to...

There must be something wrong with the ID, INTL\RXie, I dropped it and then try to re-add it, it now pops up "Windows NT user or group 'INTL\Rtxie' not found.

Although...

Here is the sqlplan file, thanks to all replies.

Msg 15404, Level 16, State 11, Procedure xp_logininfo, Line 62

Could not obtain information about Windows NT...

Do you want to see the 2 results return by exec...

Sorry I don't quite get you, what do you want me to...

THIS RETURNS ONLY TWO...

exec xp_logininfo 'INTL\RTXIE'

exec xp_logininfo 'Intl\rtxie'

exec xp_logininfo 'INTL\Rtxie'

exec xp_logininfo 'INTL\rtxie'

ALL RETURNS

Msg 15404, Level 16, State 11, Procedure xp_logininfo, Line 62

Could not obtain information about Windows NT group/user 'INTL\rtxie', error code...

arr.nagaraj (2/22/2010)

---

Having charindex function will ensure that index on a.account

doesn't get used.

Indexes are not effective when you have 'OR' conditions as well.

Can you please post the query plan that you...

Thanks, I...

Sorry, I didn't mean to, actually I didn't even know that the post was posted so many times:w00t::w00t::w00t:, I had trouble on posting it for the whole day, it always...

Lynn Pettis (2/22/2010)

---

What version of windows is being used? IIRC Windows 2003 and newer are actually case sensitive with regards to user names. (But then I may be...

Thanks Steve, how do I determine this? it has no problem adding other users from other...

ok, i believe THIS IS A SQL PROBLEM, INSTEAD OF ACTIVE DIRECTORY PROBLEM

we know Exec xp_logininfo 'intl\abc'

will tell you if the user is a valid user

for this particular...