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
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. I'm using ODBC.
How do I set the SQL7 up to accept my connection?
The sqlsrv32.dll version on the client is 3.70.09.61. I could ping the
Database machine so I know I could connect.
Any help would be really appreciatedI had to turn on SQL Authentication and Windows Authentication on. I had on
ly Windows Authentication on. This has to be set on the SQL database by rig
ht clicking the database and in Security tab select both. Restart the datab
ase and it will work.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment