SQL Server Connectivity Series - Troubleshooting SQL Server Login Failures #sqlserver #sqlconnectio

SQL Server Connectivity Series - Troubleshooting SQL Server Login Failures
18456, Severity: 14, State: 5.
Login failed for user 'login'. Reason: Could not find a login matching the name provided.
Error: 18456, Severity: 14, State: 6.
Login failed for user 'jbswiki\jvivek2k1'. Reason: Attempting to use an NT account name with SQL Server Authentication.
Error: 18456, Severity: 14, State: 8.
Login failed for user 'jvivek2k1'. Reason: Password did not match that for the login provided.
Error: 18456, Severity: 14, State: 7.
Login failed for user 'sa'. Reason: An error occurred while evaluating the password.
Error: 18470, Severity: 14, State: 1.
Login failed for user 'sa'. Reason: The account is disabled.
Error: 18456, Severity: 14, State: 5.
Login failed for user 'JBSWIKI\test'. Reason: Could not find a login matching the name provided.
Error: 18456, Severity: 14, State: 146.
Login failed for user 'JBSWIKI\test'. Reason: Token-based server access validation failed with an infrastructure error. Login lacks Connect SQL permission.
Login failed for user 'JBSWIKI\test'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)
Error: 18470, Severity: 14, State: 1.
Login failed for user 'JBSWIKI\test'. Reason: The account is disabled.
SQL Server service has been paused. No new connections will be allowed. To resume the service, use SQL Computer Manager or the Services application in Control Panel.
Login failed for user ''. (Microsoft SQL Server, Error: 17142)
Error: 18456, Severity: 14, State: 13.
Login failed for user ''. Reason: SQL Server service is paused. No new connections can be accepted at this time.
SQL Server is allowing new connections in response to 'continue' request from Service Control Manager. This is an informational message only. No user action is required.
Cannot open user default database. Login failed.
Login failed for user 'Finance'. (Microsoft SQL Server, Error: 4064)
Error: 18456, Severity: 14, State: 40.
Login failed for user 'Finance'. Reason: Failed to open the database 'DB1' specified in the login properties.
Login failed for user 'finance'. (Microsoft SQL Server, Error: 18456)
Error: 18456, Severity: 14, State: 58.
Login failed for user 'finance'. Reason: An attempt to login using SQL authentication failed. Server is configured for Integrated authentication only.

In addition to error 18456, We have other login failures as listed below,
18451-Login failed for user . Only administrators may connect at this time.
18452-Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
18458-Login failed. The number of simultaneous users already equals the '' registered licenses for this server. To increase the maximum number of simultaneous users, obtain additional licenses and then register them through the Licensing item in Control Panel.
18459-Login failed. The workstation licensing limit for SQL Server access has already been reached.
18460-Login failed. The number of simultaneous users has already reached the limit of '' licenses for this '' server. Additional licenses should be obtained and installed or you should upgrade to a full version.
18461-Login failed for user . Reason: Server is in single user mode. Only one administrator can connect at this time.
18462-The login failed for user "". The password change failed. The password for the user is too recent to change.
18463-The login failed for user "". The password change failed. The password cannot be used at this time.
18464-Login failed for user . Reason: Password change failed. The password does not meet Windows policy requirements because it is too short.
18465-Login failed for user . Reason: Password change failed. The password does not meet Windows policy requirements because it is too long.
18466-Login failed for user . Reason: Password change failed. The password does not meet Windows policy requirements because it is not complex enough.
18467-The login failed for user "". The password change failed. The password does not meet the requirements of the password filter DLL.
18468-The login failed for user. The password change failed. An unexpected error occurred during password validation.
18470-Login failed for user . Reason: The account is disabled.
18471-The login failed for user "". The password change failed. The user does not have permission to change the password.
18482-Could not connect to server '' because '' is not defined as a remote server. Verify that you have specified the correct server name. .
18483-Could not connect to server '' because '' is not defined as a remote login at the server. Verify that you have specified the correct login name. .
18485-Could not connect to server '' because it is not configured to accept remote logins. Use the remote access configuration option to allow remote logins.
18487-Login failed for user .Reason: The password of the account has expired.
18488-Login failed for user .Reason: The password of the account must be changed.