Understanding “login failed” (Error 18456) error messages in SQL Server
02-Jul-1010 Leave a comment
More human readable messages are stored in Log
Described here. 2005, but still works in 2008 R2
Viewing log
IT and business subjects
02-Jul-1010 Leave a comment