troubleshooting Question

SQL Server Error: 18456

Avatar of 219com
219com asked on
DatabasesMicrosoft SQL ServerMicrosoft SQL Server 2005
9 Comments1 Solution652 ViewsLast Modified:
I have a database that can only get accessed by one user.  All the other users get an error that states;

Connection Failed:
SQLState: '2800'
SQL Server Error: 18456
[Miscrosoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'DOMAIN\user'.

There was some Active Directory changes before this failure but all the settings for the users denied have been checked.  to put a spin on it, the user that is allowed can only access the database from her machine.  If she attempts to login to the database on another machine she gets the same errors.  I am assuming she is using some sort of cached credentials on her local workstation.  

The database is located on an SQL server and the shortcut is redirected from a file on everyone's C:/

SQL is using windows authentication but it appears this may be some sort of issue with SQL authentication not being in tune with A/D.  Just a guess.

Please help me out, I have a bunch of data entry people ready to hurl me out of a 5th story window any second.

Thanks for everyones attention.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros