Wednesday, June 17, 2009

Login Errors - State Codes

State  /   Error description
1     Account is locked out
2     User id is not valid
5     User id is not valid
6     Attempt to use a Windows login name with SQL Authentication
7     The login being used is disabled
8     Incorrect password (Password mismatch)
9     Invalid password
11-12     Login valid but server access failed
13     SQL Server service paused
16     Login valid, but not permissioned to use the target database
18     Password expired (Change your password!)
23     The server is in the process of shutting down. No new connections are allowed.
27     Initial database could not be found
38     Login valid but database unavailable (or login not permissioned)

No comments: