ODBC Failure, error 18456



I am getting the following error when trying to open a linked to sql
table in access.

Connection Failed
sqlstate 28000 sql
server error 18456

Login failed for user(Windows Authentication ID)

I set up the ODBC to use "SQL server authentication using a login ID
and password entered by user". I checked "Connect to SQL Server to
obtain default settings for the additional configuration options". I
then used a login ID that exists in SQL. When I test the connection
it works. But when I call it from Access, it reverts back to using
the user's Windows Authentication. After clicking OK, a message box
appears for connecting to sql. It shows the user ID set up in ODBC
with no password. If I uncheck the box and enter the password, it
then works... I'm stumped. I don't understand why it is trying to use
Windows Authentication.

We are running XP professional, Office 2007 and SQL Server 2005.

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

SQL Server Error 18456 1
ODBC Connection to SQL Server 2
ODBC error - help 1
TransferSpreadsheet method question 2
SQL Server Error: 18456 4
Snowflake to SSIS 0
transfer data - ODBC 1
Non- Admin connection 3