Use Trusted Connection is the default. How do I change it.

C

Clubcar

I open my Access Database. I run my query pulling information from SQL Server
Tables. The first time, it fails. The screen opens and I uncheck use Trusted
Connection, then click okay. The query runs.

How can I make the default to be unchecked for that dialog box?
 
D

Douglas J Steele

Presumably you're using a DSN to connect to SQL Server. Check that the DSN
is set up properly.
 
A

aaron.kempf

in SQL Server you mean?

you right click on the server in enterprise manager and on the security
tab you enable SQL authentication.

I prefer sql authentication to windows auth 6 days of the week
 
Top