Cannot connect to SQL Server - Defaults to Trusted Connection

R

rmcompute

A table was created which is connected to SQL Server through an ODBC
connection with a DSN file. The same DSN file is used in another database
for the same table and it works successfully. In this database the following
error is generated:

.......Login failed for user us\smithr

When OK is clicked on the above message screen, the SQL Server Login screen
is displayed with the Use Trusted Connection box checked and the user id,
smithr displayed. When the box is unchecked and the login information
existing in the DSN file is entered, it works. Can someone tell me why it
defaults to the trusted connection and not the DSN file in this database ?
 

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

Removing Trusted Connection Default for ODBC Connection 0
ODBC Connection not working when database is closed and re-opened. 3
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Connect to SQL 2000 3
Linked Tables: Remove Login Prompt 3
ODBC Sql Server Login 1
Connecting to SQL Server DB in Windows 7 1
Trusted Connection in Pass-trough query... 4

Top