MS SQL Server login failure state codes
2 and 5
Invalid userid
6
Attempt to use a Windows login name with SQL Authentication
7
Login disabled and password mismatch
8
Password mismatch
9
Invalid password
11 and 12
Valid login but server access failure (valid login, but login has no access to the server)
13
SQL Server service paused
18
Change password required