SQL Login from NTDOMAIN account
From: khanson2k (khanson2k_at_discussions.microsoft.com)
Date: 07/29/04
- Next message: Frank: "RE: master..xp_cmdshell Error 997 from GetProxyAccount"
- Previous message: Kevin McDonnell [MSFT]: "RE: Password security"
- Next in thread: Kevin McDonnell [MSFT]: "RE: SQL Login from NTDOMAIN account"
- Reply: Kevin McDonnell [MSFT]: "RE: SQL Login from NTDOMAIN account"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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.
- Next message: Frank: "RE: master..xp_cmdshell Error 997 from GetProxyAccount"
- Previous message: Kevin McDonnell [MSFT]: "RE: Password security"
- Next in thread: Kevin McDonnell [MSFT]: "RE: SQL Login from NTDOMAIN account"
- Reply: Kevin McDonnell [MSFT]: "RE: SQL Login from NTDOMAIN account"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]