What problem is it?-Login failed for user 'xxx'

[Lilyli]

Hello,

We have a COM add-in created in VB6.0 for Outlook 2000. When the add-in runs, it will connect to SQL Server 2000 DB. Sometimes our user got the following error:
Run-time error '-2147217843(80040e4d)':[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'xxx'.

I never experienced this problem. I checked the ODBC connection, found on my PC, the network Libraries is TCP/IP. But on other users' PC is Named Tipes.

I have no idea why this error happend. Does anybody can help me out?

Your any help will be greately appreciated!

Thanks,

 

[Catadmin]

How many ODBCs does the user have with the same name? Check System, File and User. This shouldn't have anything to do with the TCP/IP or Named Pipes protocols.

I've found if there are more than 1 ODBC with a specific name, the wrong one will attempt to activate, causing bad login attempts.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[Lilyli]

Hello Catadmin,

Thanks for your answer.
Most of our users use a temporary connection using ADO that's defined within the program (not ODBC).

Right now only three users have the ODBC connection for that database. We set up one user with 'User DSN' called 'xxx' using NT Authentication. The other two users with 'System DSN' called 'xxx'(the same name as that one user) using SQL Server Authentication.

Is this the reason caused that problem? We did not have this problem when we used SQL Server 7.

Thanks again,