Understanding “login failed” (Error 18456) error messages in SQL Server

 
More human readable messages are stored in Log
 
Described here. 2005, but still works in 2008 R2
 
Viewing log

Leave a comment