Friday, March 23, 2012

Frustrating Authentication Errors

I have a prospective client evaluating our software that uses a SQL backend
and we're struggling with some errors I can't recreate here in our lab.
When he logs into his laptop and tried to access the SQL db, he get's this
error:
"Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection"
However, when he or the SQL admin log into the SQL admin's PC both can
access the SQL db just fine.
This error only happens on the tester's PC. He even re-imaged the PC and it
still fails. He's running WinXP.
They are running SQL 2000 on a Windows Server 2003 box. Use a mix of AD and
SQL authentication. In this case they have created users for him in both AD
and SQL for this db.
Suggestions'make named pipes the priority on the clients.
"smutny" <smutny@.discussions.microsoft.com> wrote in message
news:780B2EEF-7C85-4DCE-854B-25F4409DE61F@.microsoft.com...
>I have a prospective client evaluating our software that uses a SQL backend
> and we're struggling with some errors I can't recreate here in our lab.
> When he logs into his laptop and tried to access the SQL db, he get's this
> error:
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
> However, when he or the SQL admin log into the SQL admin's PC both can
> access the SQL db just fine.
> This error only happens on the tester's PC. He even re-imaged the PC and
> it
> still fails. He's running WinXP.
> They are running SQL 2000 on a Windows Server 2003 box. Use a mix of AD
> and
> SQL authentication. In this case they have created users for him in both
> AD
> and SQL for this db.
> Suggestions'

No comments:

Post a Comment