Tim Radney enumerates the causes of an error:
Working with thousands of instances of Microsoft SQL Server, I often encounter users having issues. A common error is 18456 which indicates a login failure. Some common solutions are listed below.
Click through for the list.