Access to SQL Server 7 connection

Hello
Hope someone can point me to the right direction on this:
I have a MSSQL 7 database on a NT box and I would like to
use MSAccess as a front end to the database. The database
is on its own network and I can connect if I have another
computer on that network. When I try to connect from a
computer that is on the other side of the database
network, through a Linux firewall, I get the following
error:
Login failure for user '(null)'. Reason: Not associated
with a trusted SQL Server Connection
How do I set the SQL7 up to accept my connection?The error indicates that you are using NT authentication to connect. It
indicates that the user who is trying to connect cannot be valicated on the
domain where the SQL Server resides. You can possilby connect to SQL Server
using a SQL login rather than an NT login.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Hi
I tried both the NT and SQL authentication and got the
same result. With the SQL authentication I used a user
name that I created on the database.|||What is the version of the sqlsrv32.dll on the client machine you are
trying to connect from? I am assuming that you are using ODBC to connect.
You should not get that error using SQL authentication. That error is
specific to NT authentication. However there is a problem with some of the
SQL Server ODBC drivers that can cause similar problems.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||The sqlsrv32.dll version is 3.70.09.61. I could ping the
Database machine so I know I could connect.
Thanks for your help.|||Hello Can anyone help?