Possible causes and solutions for State 11 If you are not seeing $ in the user name, then it is a user account.This mostly happens when a “service” running on the remote machine is connecting to SQL. If you are seeing $ in the user name, then it is a machine account / computer account.It would come for windows accounts only.There are few things to note about this message. Reason: Token-based server access validation failed with an infrastructure error. Īs we can see, the message in ERRORLOG file is having state 58 and exact reason.Ĭoming back to message in the title, here is the complete message Server is configured for Windows authentication only. Reason: An attempt to login using SQL authentication failed. SQL SERVER – Where is ERRORLOG? Various Ways to Find its Location If you are new to SQL Server then use below to find ERRORLOG It is important to note that SQL Server does not tell the exact state to the client and it would be a state 1 always. All login failed for user message would have error number 18456 but the state of the message in the ERRORLOG would tell the exact cause of login failure. If you ever talk to an SQL Expert about login failed for user, he/she might ask for the state of the message or complete error message.
Why line app for pc failed login how to#
Let us learn about how to fix the error login failed. This is one of the most common error searched on my blog search ( ) and lately I realized that I have not written any blog about the cause of such error and fixing that.