Login failed for user <xx>, Msg 18456, Level 14, State 1

Login failed for user <xx>, Msg 18456, Level 14, State 1http://blogs.msdn.com/b/sql_protocols/archive/2007/06/30/login-failed-for-user-xx-msg-18456-level-14-state-1.aspxThis post focus on a typical cause of sql login failure issue described as the title. In real world, a customer log on to the machine as a domain\user or local machine accout, he can connec to SQL Server through SQL Server Management Studio. Howeveren-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)re: Login failed for user <xx>, Msg 18456, Level 14, State 1http://blogs.msdn.com/b/sql_protocols/archive/2007/06/30/login-failed-for-user-xx-msg-18456-level-14-state-1.aspx#6971435Thu, 03 Jan 2008 23:05:09 GMT91d46819-8472-40ad-a661-2c78acb4018c:6971435John<p>These issue i have had with this error message is our application using the jtds open source driver  which by default uses NTLM authentication.  Our client used NTLMv2.  We were able to put ';useNTLMv2\=true' into our connection string and no longer got this error. </p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=6971435" width="1" height="1">