Automatically Connecting to SQL Database Tables

[RogerCooper]

We recently converted our ERP from Oracle to SQL Server. While Oracle automatically saved the password, SQL Server demands the password be typed in, creating a problem for activities run overnight.

What is the best way to connect to SQL Server automatically?

 

[pbaldy]

If you're linking the tables yourself using a DSN, there's an option to save the password during that process. Many of us use DSN-less connections. One method:

http://www.accessmvp.com/DJSteele/DSNLessLinks.html

 

[Galaxiom]

What is the best way to connect to SQL Server automatically?

Use Windows security to connect.

 

[pbaldy]

Good point, I use Windows authentication myself.