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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Presumably you're using a DSN to connect to SQL Server. Check that the DSN
is set up properly.
 
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
 
You must log in or register to reply here.

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

Use Trusted Connection on SQL Link table 3
Access 2010 error 2950 3
What are the steps to fix damaged MDF files in SQL Server? 0
Exit Before SQL Server Error Message 2
ODBC Connection not working when database is closed and re-opened. 3
How To Check SQL Connection (DAO) 2
SQL Server Back End 2
ODBC Sql Server Login 1

Back
Top