Advertisement

06.26.2007 at 01:09PM PDT, ID: 22659544
[x]
Attachment Details

SQL State 28000 - Error 18456 Logon Failed For User

Asked by sfrisk in MS SQL Server

Tags: 28000, 18456, sql, error, state

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.  Start Free Trial
[+][-]06.26.2007 at 02:17PM PDT, ID: 19367902

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.27.2007 at 05:09AM PDT, ID: 19371451

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.01.2007 at 07:45AM PDT, ID: 19399092

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.02.2007 at 05:17AM PDT, ID: 19402718

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.02.2007 at 06:05AM PDT, ID: 19403015

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.02.2007 at 06:22AM PDT, ID: 19403182

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.02.2007 at 06:42AM PDT, ID: 19403318

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.02.2007 at 08:05AM PDT, ID: 19404078

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.02.2007 at 09:10AM PDT, ID: 19404706

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.02.2007 at 10:25AM PDT, ID: 19405311

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.02.2007 at 11:05AM PDT, ID: 19405640

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.02.2007 at 11:09AM PDT, ID: 19405675

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.02.2007 at 11:10AM PDT, ID: 19405683

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: 28000, 18456, sql, error, state
Sign Up Now!
Solution Provided By: twoboats
Participating Experts: 1
Solution Grade: A
 
 
[+][-]07.02.2007 at 11:13AM PDT, ID: 19405704

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.02.2007 at 11:40AM PDT, ID: 19405906

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32