SQL State 28000 - Error 18456 Logon Failed For User
Posted on 2007-06-26
I have a SQL database (SQL 2000) that has an Access2000 front end to it. Everything works ok for me, but for others it is not. When they click on the table or the report, they get "Connection Failed - SQLState: "28000" SQL Server Error 18456. Login failed for user...." I have read the previous posts on this error and have tried most of them. I am missing something. Under the ODBC connection on the client, I have the User DSN and System DSN set up for both of the databases on the SQL server. I also have the Access database set up under User DSN. The user is set up as a user on the server where the SQL database resides, with the same permissions that I have. Under the database in Enterprise Manager, the user is set up under "Logins". I have not deleted all of the table links and the ODBC connection, I'm not sure how to do this.
The user is able to get into the Access program by unchecking Trusted Connection and typing in her password, but this is a pain. How do I get this to be automatic. I have compared my settings to hers and they seem the same.