ADP - connecting to a database on a different machine

[AMD414]

Good afternoon everyone. I am trying to create an ADP that connects to
a database located on a remote machine. It is returning the error "Not
associate with a trusted SQL Server Connection." The machine I am
using is running MSDE, however I am not sure about the remote machine.
Could it be a matter of the remote machine not having MSDE, or are we
not using the correct password? (Sorry if any clarifications are
needed).

Thank you

 

[Sylvain Lafontaine]

Wrong password or unknown login. Don't forget that for a remote machine
that is not on the same domain, you cannot use Windows authentification or
Integrated Security to connect; you will have to set up and use a SQL-Server
login.