troubleshooting Question

SQL Server Error:  18452 Login Failed for user ''

Avatar of Roxanne25
Roxanne25 asked on
Microsoft SQL Server 2005Microsoft SQL Server
7 Comments2 Solutions1065 ViewsLast Modified:
Hi, we are having a strange intermittant problem with some of our SQL logins.  At first, we thought it was an isolated problem with a developer on my team.  He was getting the following error intermittantly when connecting to the database:

SQLState: '28000'
SQL Server Error: 18452
Login Failed for User ''.  The user is not associated with a trusted SQL Server connection.

We are operating in mixed mode and he is accessing the database via a domain account.  It just happens sporatically and the error message just has '' as the username.  He can try again a few minutes or few hours later and it works fine.

At first we thought it was something with his machine and our Networking people could not identify any problems.

Today, I got a help desk ticket from a user who is using MS Access to connect to the SQL Server via ODBC.  He has been using this method without problem for over a year and just started having the exact same error message popping up intermittantly.

I also access the database the same way that the developer does and I have never had this problem.  We are all using domain accounts.  We have very few local SQL logins and those are only used by automated processes and internal db stuff.

Does anybody have any clue why this is happening?  I tried googling it and the only solutions I found actually had something showing up in the error message for a username and said to enable mixed mode...but we're already running in mixed mode.

Thanks!
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 7 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 2 Answers and 7 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