Updated in 2020 with a few new entries, this is a fairly comprehensive list of the reasons behind various 18456 error messages.
July 2020
For this month's T-SQL Tuesday, Kerry Tyler asks us to talk about something that went wrong. I had plenty to choose from, and went way back to ~2002 for this short story.