Problem with Trusted Connection

[kelele]

I have a peer to peer network with three computers. All are running MS 2000 O/S One acts as the server, hosting the SQL Server 7.0 database and the other two act as clients.

The clients run MS Access applications with the tables linked in using an ODBC connection I created in the control panel.

I recently added a third client with the same configurations. The access application on this new client keeps comming up with a dialog box saying it cannot connect to the database using the trusted connection. The dialog box has a check box "use trusted connection". When I uncheck this box, it allows the client to connect to the tables.

What do I need to do to keep this dialog box from poping up all the time?

I have searched microsoft knowledge base but their solutions only pertain to client/server networks.

 

[tlbroadbent]

Do you want to connect with SQL or NT authentication? If you want to use NT authentication make sure the login on the 3rd client is also a login in SQL Server.

If the applciation tries SQL Authentication and gets that message you will probably need to upgrade the MDAC version on the client. There is a known bug in MDAC 2.6 and ODBC 3.6 that ignores the authentication setting in the DSN. Check the MS KB article at...

http://support.microsoft.com/support/kb/articles/Q279/5/26.ASP

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.