Login failed for user ''. The user is not associated with a trusted SQL Server connection
We are observing the below error in SQL error log file. 2014-08-10 06:20:04.80 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: X.X.X.X] 2014-08-10 06:20:05.79 Logon Error: 18452, Severity: 14, State: 1. four application servers are doing the transaction with this DB server using same SQL login. We are getting successfull transactions as well in all application servers. Please help to understand why this error is coming for some of the tansactions only.
Hello we need more information to help you - Has anything in the environment changed? - Do the failed connections have anything in common? e.g. Are they all from teh same service or application? Do they all come from one server? - What type of application is trying to access the database? - What authentication mode is the Database server in? - Is it a single server or a cluster?