Summary
This document contains information about the common SQL Server State codes related to login failure and a description of these error codes.
Background
You might notice that SQL log messages display logon failure errors, attempting to interoperate Citrix products with SQL Server. Each failed login attempt is associated with Severity and State codes as shown in the following sample screen shot:
SQL Server State Codes
The SQL server returns the correct State code to identify the source of the issue. In the preceding example, the login failed due to invalid permission on the target database.
Refer the following table to identify the common error State codes and a description of the error:
State |
Error Description |
1 |
Account is locked out |
2 |
User ID is not valid |
3-4 |
Undocumented |
5 |
User ID is not valid |
6 |
Attempt to use a Windows login name with SQL Authentication |
7 |
The login being used is disabled and password mismatch |
8 |
Incorrect password |
9 |
Invalid password |
10 |
Related to a SQL login being bound to Windows domain password policy enforcement. |
11-12 |
Login valid but server access failed |
13 |
SQL Server service paused |
14 |
Account being used to access the server do not have permission to log in to the server |
16 |
Login valid, but is missing the required permission to use the target database. |
18 |
Password expired- Change password required |
23 |
Simultaneous action of shutting down SQL SERVER and any incoming logins to SQL server |
27 |
Initial database could not be found |
38 |
Login valid but database unavailable (or login not permissioned) |
40 |
New login is created with the default db option being set to a database which is OFFLINE or unavailable |
58 |
An attempt to login using SQL authentication failed. Server is configured for Windows authentication only |
This document applies to:
- EdgeSight for Endpoints 5.0
- EdgeSight for Endpoints 5.1
- EdgeSight for Endpoints 5.2
- EdgeSight for Endpoints 5.3
- EdgeSight for XenApp 5.0
- EdgeSight for XenApp 5.1
- Feature Pack 1 for Presentation Server 4.5
- Presentation Server 4.0 for Microsoft Windows 2000
- Presentation Server 4.0 for Microsoft Windows 2003
- Presentation Server 4.0 x64 Edition
- Presentation Server 4.5 for Windows Server 2003
- Presentation Server 4.5 for Windows Server 2003 x64 Edition
- Provisioning Services 5.0
- Provisioning Services 5.1
- Provisioning Services 5.6
- XenApp 5.0 for Windows Server 2003 x64
- XenApp 5.0 for Windows Server 2003 x86
- XenApp 5.0 for Windows Server 2008 x64
- XenApp 5.0 for Windows Server 2008 x86
- XenDesktop 4 x32
- XenDesktop 4 x64
- XenDesktop 5 x32
- XenDesktop 5 x64
Source: Common Severity Login Failed State Codes with Descriptions