I recently updated SQL Server 2000 to SP4 for an application and was reworking the OBDC driver to use an IP rather than DNS name to hit the server.
Only issue is now when I test the connection it fails for every user except if I log in as my domain account and set the driver then. But if I log in then as anyone they fail authentication.
I have the following checked in OBDC:
With Windows NT Authentication using the network ID
Connect to SQL Server to obtain default settings for the additional configuration options
If I choose the second option to manually use a password no credentials I use work.
The SQL Server Authentication is set to SQl Server and Windows