SQL Login from NTDOMAIN account

From: khanson2k (khanson2k_at_discussions.microsoft.com)
Date: 07/29/04


Date: Thu, 29 Jul 2004 14:07:17 -0700

I have an interesting issue. I added 4 users to SQL server security from their NT Domain account. One of the users gets a connection failed in the script that he runs. The exact error is: Login failed for user '<null>'. Reason: Not accociated with a trusted SQL Server connection.
Here's what I think the problem might stems from, if someone can tell me if I'm off base or not. We had to rename our NT accounts to comply with a new company. This user happened to have an NT id already on this SQL Server, so I had to delete it and add his new ID from the domain. I'm wondering if there is a SID vs user ID confict when trying to establish a connection, and what can I do about it? Thanks.