To get to the point, I'm having issues accessing SQL databases. The specific error is as follows:
SQL state: '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.
Here's the setup:
The workstation(s) and the SQL Server are in different Windows Domains - no trust relationship allowed. The DBs are Access front-ends and I've set up an ODBC connection to the SQL Server using SQL authentication and it passes all tests. The SQL Server is set up in mixed authentication mode (I've scoured Microsoft Support on this). When the user(s) attempt to access the DB, they recieve the above error, followed by a SQL Authentication box. If you clear the trusted connection box and enter in the SQL account password, you get a little farther before getting another 18452 error and the cycle starts again until whatever form/report/query opens.
To me, this seems like a timeout issue. Is there anything I can do to fix this?
The SQL Server is running on a 2K3 server and the clients are 2K.
Thanks in advance,