SQL Server Error: 18456

S

Shaun Mathew

Good Afternoon;

Currently I am having issues with ODBC on Access 97. When
I am accessing an application using access I receive this
error:

Connection Failed:
SQL state 28000
SQL Server Error 18456
Microsoft ODBC SQLServer Driver SQL Server Login failed
for user.

As a result I changed and reconfigured settings for ODBC
However problem still occurs please advise.

If you require further information Please let me know

Thank you
 
V

Van T. Dinh

It looks like there are problems with logging into the server. Have you got
the right permission (SQL Server authentication or NT Network
authentication).

HTH
Van T. Dinh
MVP (Access)
 

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 4
SQL Server Error 18456 1
SQL Server Login 1
ODBC Failure, error 18456 0
Connection Failed SQLState: '28000' 2
Upsizing wizard access Sql Server express 7
SQL Connection Error with MS Access 7
webservice - dsn - sql server 1

Top