brandon owensby

I have a computer with SQL Server on it that every computer in our office
can connect to except one. The one that cannot connect gets the following
error message.

Server: Msg 18456, Level 16, State1
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'Brandon'

I'm using the same login on any computer I've tried. I know I didn't just
make a typo because I've tried retyping the password a bunch of times. I
notice the problem because I process that used to run every day started
failing. It was quite a while before I noticed it was failing but when I
looked into why it was because it could no longer log into sql server. What
could be wrong? Why only this computer? Any help would be greatly
appreciated!!

Thanks,
Brandon

jan doggen

Hi Brandon

- MDAC versions up-to-date?
- Connections through TCP/IP or named pipes? Any differences there?

Those are the things that come up ;-)

Bye
Jan