I am attempting to connect a machine from Domain A to a SQL 2000 SP3 Server
in Domain B (SBS 4.5 no trusts allowed). I am using a system DSN using SQL
Server authentication. When I attempt to connect to the SQL server I get the
following error message:

===============
Connection failed
SQLState 28000
SQL Server Error 18452
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
'(null)'.
Reason: Not associated with a trusted SQL Server connection.
================

When I click on OK, another SQL Server login pop-up box appears with the
"Use trusted connection" checkbox pre-checked. If I uncheck this then it
allows me to put in the correct user/password combination.

What am I missing here? I have already tried updating to MDAC 2.8 SP1on the
client. Still cannot connect. DSN tests work fine under TCP/IP, fails under
Named Pipes.

Any ideas of what to try next?