ADP to run on another computer

[Tangier]

Hi All,

I have an adp application that works beautifully on my computer. When
I move the app to a shared folder on a different computer, it does not
work.

I realize that the application, where it is sitting, prob does not
have permission to access SQL server. How can I set up this adp app on
a shrec computer successfully?

 

[Sylvain Lafontaine]

Well, if it doesn't have access to the SQL-Server, then you have to solve
this problem on the SQL-Server itself and not on the client side (the ADP
application). There are many reasons why any client application (and not
only an ADP application) can't connect to a SQL-Server; however, you haven't
given any detail at all on your current setting; for example, where the
SQL-Server itself is located or what kind of login (Windows account
(Integrated Security) or SQL-Server Login Account) you are trying to use.

One place to start looking would be at:
http://www.linglom.com:80/2009/03/28/enable-remote-connection-on-sql-server-2008-express/

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)