I have an Access 2000 DB that has an ODBC connection to a SQL 6.5
Server. The server is runing in Mixed Mode (SQL Authentication and NT
Authentication). I can open the ODBC connections if I use SQL
authentication (my SQL username and password). I cannot use a trusted
connection to open the Access DB. I can use a trusted connection to
open Enterprise Manager.

I have the following DLL versions on my PC:
ntwdblib.dll 7.00.623
dbnmpntw.dll 8.0.1.85

The ODBC connection I have set up is using NT securty and when I test
it works.

The error I get in Access is:

Connection failed:
SQL State '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User:
Reason: Not associated with a trusted SQL Server connection.

Any ideas on what I am doing wrong?

thanks
Brian

Probably the 'ODBC connection' from the 'Access 2000 DB' has
not been set to use a trusted connection. How are you doing
it?

(david)

"Brian D'Altilio" <bdaltilio@yahoo.com> wrote in message
news:b3f8bec3.0309181047.3fbdcd33@posting.google.c om...
> I have an Access 2000 DB that has an ODBC connection to a SQL 6.5
> Server. The server is runing in Mixed Mode (SQL Authentication and NT
> Authentication). I can open the ODBC connections if I use SQL
> authentication (my SQL username and password). I cannot use a trusted
> connection to open the Access DB. I can use a trusted connection to
> open Enterprise Manager.
>
> I have the following DLL versions on my PC:
> ntwdblib.dll 7.00.623
> dbnmpntw.dll 8.0.1.85
>
> The ODBC connection I have set up is using NT securty and when I test
> it works.
>
> The error I get in Access is:
>
> Connection failed:
> SQL State '28000'
> SQL Server Error: 18452
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User:
> Reason: Not associated with a trusted SQL Server connection.
>
> Any ideas on what I am doing wrong?
>
> thanks
> Brian