ADP - connecting to a database on a different machine

  • Thread starter Thread starter AMD414
  • Start date Start date
A

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Am I disturbing a machine in production floor if I access its database remotely? 4
ADP remote connection issue 10
Multiple instances of an adp... 5
ADP Connection to Large Database 6
Unable to make design changes in .adp connected to SQL server 2008 1
Start up Options ignored in ADP? 1
Does Microsoft recommend databases or projects to connect to SQL s 1
Unable to connect to ADP database 14

Back
Top