[dba-SQLServer]ADP auto login to SQL server

One way to avoid this is to use windows authentication, but if you want 
to stick with SQL authentication then I suggeet you open up the 
connection window (file|Connection), and check the box that says save 
password.


Liam Meadows wrote:

> How is it possible to set an ADP to auto login to an SQL database.
> Obviously I will create an account thatisn't able to alter things I
> don't want them to but I don't want the shopfloor to keep having to type
> in a login and password every time the ADP is started up.
> 
> Cheers
> 
> Liam
> 


-- 
-Francisco