SQL Server System Errors: 41000 - 41999
List of error messages between 41000 and 41999 in SQL Server 2017.
These error messages are all available by querying the sys.messages
catalog view on the master
database.
message_id | severity | is_event_logged | text |
---|---|---|---|
41000 | 16 | 0 | Failed to obtain the local Windows Server Failover Clustering (WSFC) handle (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41001 | 16 | 0 | Failed to obtain local computer name (Error code %d). The supplied buffer may be too small, or there is a system error. For information about this error code, see "System Error Codes" in the operating system documentation. |
41002 | 16 | 0 | Failed to obtain the local Windows Server Failover Clustering (WSFC) node handle (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41003 | 16 | 0 | Failed to obtain the local Windows Server Failover Clustering (WSFC) node ID (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41004 | 16 | 0 | Failed to obtain the Windows Server Failover Clustering (WSFC) group handle for cluster group with name or ID '%s' (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster group name or ID is invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41005 | 16 | 0 | Failed to obtain the Windows Server Failover Clustering (WSFC) resource handle for cluster resource with name or ID '%s' (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster resource name or ID is invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41006 | 16 | 0 | Failed to create the Windows Server Failover Clustering (WSFC) group with name '%s' (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster group name is invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41007 | 16 | 0 | The Windows Server Failover Clustering (WSFC) group control API returned error code %d. If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41008 | 16 | 0 | Failed to create the Windows Server Failover Clustering (WSFC) resource with name '%s' and type '%s' (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster resource name or type is invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41009 | 16 | 0 | The Windows Server Failover Clustering (WSFC) resource control API returned error code %d. If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41010 | 16 | 0 | Failed to bring the Windows Server Failover Clustering (WSFC) group online (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster group name is invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41011 | 16 | 0 | Failed to take the Windows Server Failover Clustering (WSFC) group offline (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster group name is invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41012 | 16 | 0 | The Windows Server Failover Clustering (WSFC) node control API returned error code %d. If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41013 | 16 | 0 | Failed to obtain the Windows Server Failover Clustering (WSFC) resource enumeration handle (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster resource handle is invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41014 | 16 | 0 | Failed to enumerate the Windows Server Failover Clustering (WSFC) resources (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster resource enumeration handle is invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41015 | 16 | 0 | Failed to obtain the Windows Server Failover Clustering (WSFC) node handle (Error code %d) for node '%.*ls'. If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster node name is invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41016 | 16 | 0 | Failed to remove a node from the possible owner list of a Windows Server Failover Clustering (WSFC) resource (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster resource or node handle is invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41017 | 16 | 0 | Failed to add a node to the possible owner list of a Windows Server Failover Clustering (WSFC) resource (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster resource or node handle is invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41018 | 16 | 0 | Failed to move a Windows Server Failover Clustering (WSFC) group to the local node (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster group or node handle is invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41019 | 16 | 0 | Failed to drop a Windows Server Failover Clustering (WSFC) group with name or ID '%.*ls' (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster group name or ID is invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41020 | 16 | 0 | Failed to find a String property (property name '%s') of the Windows Server Failover Clustering (WSFC) resource with name or ID '%.*ls' (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41021 | 16 | 0 | Failed to find a DWORD property (property name '%s') of the Windows Server Failover Clustering (WSFC) resource with ID '%.*ls' (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41022 | 16 | 0 | Failed to create a Windows Server Failover Clustering (WSFC) notification port with notification filter %d and notification key %d (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41023 | 16 | 0 | The Windows Server Failover Clustering (WSFC) change handle is invalid because a WSFC notification port has not been created or has been closed. Create a new WSFC notification port and retry the operation. |
41024 | 16 | 0 | Failed to register additional Windows Server Failover Clustering (WSFC) change notifications with notification filter %d and notification key %d (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41025 | 16 | 0 | Failed to receive Windows Server Failover Clustering (WSFC) change notifications (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41026 | 10 | 0 | Failed to create the Windows Server Failover Clustering (WSFC) group with name '%ls'. The WSFC group with the specified name already exists. Retry the operation with a group name that is unique in the cluster. |
41027 | 16 | 0 | Failed to start the Windows Server Failover Clustering (WSFC) change listener (SQLOS error code %d). SQL Server may not have sufficient resources to start the WSFC change listener. If the condition persists, the SQL Server instance may need to be restarted. |
41028 | 16 | 0 | Failed to open Windows Server Failover Clustering (WSFC) registry root key (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41029 | 16 | 0 | Failed to open the Windows Server Failover Clustering (WSFC) resource registry key '%.*ls' (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41030 | 16 | 0 | Failed to open the Windows Server Failover Clustering registry subkey '%.*ls' (Error code %d). The parent key is %sthe cluster root key. If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. If the corresponding availability group has been dropped, this error is expected. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41031 | 16 | 0 | Failed to create the Windows Server Failover Clustering (WSFC) registry subkey '%.*ls' (Error code %d). The parent key is %sthe cluster root key. If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41032 | 16 | 0 | Failed to delete the Windows Server Failover Clustering (WSFC) registry subkey '%.*ls' (Error code %d). The parent key is %sthe cluster root key. If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41033 | 16 | 0 | Failed to retrieve the Windows Server Failover Clustering (WSFC) registry value corresponding to name '%.*ls' (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41034 | 16 | 0 | Failed to set the Windows Server Failover Clustering (WSFC) registry value corresponding to name '%.*ls' (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41035 | 16 | 0 | Failed to enumerate Windows Server Failover Clustering (WSFC) registry value (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41036 | 16 | 0 | Failed to delete the Windows Server Failover Clustering (WSFC) registry value corresponding to name '%.*ls' (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41037 | 16 | 0 | Failed to obtain a Windows Server Failover Clustering (WSFC) object enumeration handle for objects of type %d (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41038 | 16 | 0 | Failed to enumerate Windows Server Failover Clustering (WSFC) objects (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster object enumeration handle is invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41039 | 16 | 0 | An availability group replica already exists on the node '%.*ls'. Each node can contain only one replica of an availability group. Please choose another node to host the new replica. |
41040 | 16 | 0 | Failed to remove the availability group replica '%.*ls' from availability group '%.*ls'. The availability group does not contain a replica with the specified name. Verify the availability group and replica names and then retry the operation. |
41041 | 16 | 0 | SQL Server instance to cluster node map entry cannot be found for the SQL Server instance '%.*ls' and group ID '%.*ls'. The specified SQL Server instance name is invalid, or the corresponding registry entry does not exist. Verify the SQL Server instance name and retry the operation. |
41042 | 16 | 0 | The availability group '%.*ls' already exists. This error could be caused by a previous failed CREATE AVAILABILITY GROUP or DROP AVAILABILITY GROUP operation. If the availability group name you specified is correct, try dropping the availability group and then retry CREATE AVAILABILITY GROUP operation. |
41043 | 16 | 0 | For availability group '%.*ls', the value of the name-to-ID map entry is invalid. The binary value should contain a resource ID, a group ID, and their corresponding lengths in characters. The availability group name may be incorrect, or the availability group configuration data may be corrupt. If this error persists, you may need to drop and recreate the availability group. |
41044 | 16 | 0 | Availability group name to ID map entry for availability group '%.*ls' cannot be found. The availability group name may be incorrect. If this is a WSFC availability group, the availability group may not exist in this Windows Server Failover Cluster. Verify the availability group exists and that the availability group name is correct and then retry the operation. |
41045 | 16 | 0 | Cannot add database '%.*ls' to the availability group '%.*ls', because there is already a database with the same name in the availability group. Please verify that the database and availability group names specified are correct. |
41046 | 16 | 0 | Cannot add replica '%.*ls' to the availability group '%.*ls', because there is already a replica with the same name in the availability group. Please verify the replica and availability group names specified are correct. |
41047 | 16 | 0 | Failed to obtain the Windows Server Failover Clustering (WSFC) node state for the local WSFC node (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41048 | 10 | 1 | Always On Availability Groups: Local Windows Server Failover Clustering service has become unavailable. This is an informational message only. No user action is required. |
41049 | 10 | 1 | Always On Availability Groups: Local Windows Server Failover Clustering node is no longer online. This is an informational message only. No user action is required. |
41050 | 10 | 1 | Always On Availability Groups: Waiting for local Windows Server Failover Clustering service to start. This is an informational message only. No user action is required. |
41051 | 10 | 1 | Always On Availability Groups: Local Windows Server Failover Clustering service started. This is an informational message only. No user action is required. |
41052 | 10 | 1 | Always On Availability Groups: Waiting for local Windows Server Failover Clustering node to start. This is an informational message only. No user action is required. |
41053 | 10 | 1 | Always On Availability Groups: Local Windows Server Failover Clustering node started. This is an informational message only. No user action is required. |
41054 | 10 | 1 | Always On Availability Groups: Waiting for local Windows Server Failover Clustering node to come online. This is an informational message only. No user action is required. |
41055 | 10 | 1 | Always On Availability Groups: Local Windows Server Failover Clustering node is online. This is an informational message only. No user action is required. |
41056 | 16 | 0 | Availability replica '%.*ls' of availability group '%.*ls' cannot be brought online on this SQL Server instance. Another replica of the same availability group is already online on the node. Each node can host only one replica of an availability group, regardless of the number of SQL Server instances on the node. Use the ALTER AVAILABILITY GROUP command to correct the availability group configuration. Then, if the other replica is no longer being hosted on this node, restart this instance of SQL Server to bring the local replica of the availability group online. |
41057 | 16 | 0 | Failed to create the Windows Server Failover Clustering (WSFC) resource with name '%ls'. The WSFC resource with the specified name already exists. Retry the operation with a resource name that is unique in the cluster. |
41058 | 10 | 0 | Always On: The local replica of availability group '%.*ls' is starting. This is an informational message only. No user action is required. |
41059 | 10 | 0 | Always On: Availability group '%.*ls' was removed while the availability replica on this instance of SQL Server was offline. The local replica will be removed now. This is an informational message only. No user action is required. |
41060 | 16 | 0 | The Cyclic Redundancy Check (CRC) value generated for the retrieved availability group configuration data does not match that stored with the data for the availability group with ID '%.*ls'. If this is a WSFC availability group, the availability group data in the WSFC store may have been modified outside SQL Server, or the data is corrupt. If the error persists, you may need to drop and recreate the availability group. |
41061 | 10 | 0 | Always On: The local replica of availability group '%.*ls' is stopping. This is an informational message only. No user action is required. |
41062 | 16 | 0 | The ID of availability group '%.*ls' in local data store is inconsistent with that in the Windows Server Failover Clustering (WSFC) data store. The availability group may have been dropped and recreated while the SQL Server instance was offline, or while the WSFC node was down. To resolve this error, drop the availability group and then recreate it. |
41063 | 16 | 0 | Windows Server Failover Clustering (WSFC) detected that the availability group resource with ID '%.*ls' was online when the availability group was not actually online. The attempt to synchronize the WSFC resource state with the availability group state failed (Error code: %d). For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41064 | 16 | 0 | Failed to set local node as sole preferred owner for the Windows Server Failover Clustering (WSFC) group with ID '%.*ls' (Error code: %d). The WSFC group might be in state that cannot accept the request. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41065 | 16 | 0 | Cannot bring the Windows Server Failover Clustering (WSFC) resource (ID: '%.*ls') online at this time. The WSFC resource is not in a state that can accept the request. Wait for the WSFC resource to enter a terminal state, and retry the operation. For information about this error, see error code 5023 in "System Error Codes" in the Windows Development documentation. |
41066 | 16 | 0 | Cannot bring the Windows Server Failover Clustering (WSFC) resource (ID '%.*ls') online (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the WSFC resource may not be in a state that could accept the request. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41067 | 16 | 0 | Cannot drop the Windows Server Failover Clustering (WSFC) group (ID or name '%.*ls') at this time. The WSFC group is not in a state that could accept the request. Please wait for the WSFC group to enter a terminal state and then retry the operation. For information about this error, see error code 5023 in "System Error Codes" in the Windows Development documentation. |
41068 | 16 | 0 | Failed to enumerate the Windows Server Failover Clustering (WSFC) registry key (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41069 | 16 | 0 | The existence of availability group data for the availability group '%.*ls' in the Windows Server Failover Clustering (WSFC) store could not be determined. The local WSFC node may be down, or a previous CREATE AVAILABILITY GROUP or DROP AVAILABILITY GROUP operation has failed. Please use DROP AVAILABILITY GROUP command to clean up previously failed operations. Verify that the local WSFC node is up before retrying the operation. |
41070 | 16 | 0 | Configuration data for the availability group with Windows Server Failover Clustering (WSFC) resource ID '%.*ls' is not found in the WSFC data store. The availability group may have been dropped, or a previous CREATE AVAILABILITY GROUP or DROP AVAILABILITY GROUP operation has failed. Please use DROP AVAILABILITY GROUP command to clean up previously failed operations before retrying the current operation. |
41071 | 16 | 0 | Cannot read the persisted configuration of Always On availability group with corresponding resource ID '%.*ls'. The persisted configuration is written by a higher-version SQL Server that hosts the primary availability replica. Upgrade the local SQL Server instance to allow the local availability replica to become a secondary replica. |
41072 | 16 | 0 | The ID of availability group '%.*ls' in local data store does not exist in the Windows Server Failover Clustering (WSFC) data store. The availability group may have been dropped but the current WSFC node was not notified. To resolve this error, try to recreate the availability group. |
41073 | 16 | 0 | The database '%.*ls' cannot be removed from availability group '%.*ls'. This database does not belong to the availability group. |
41074 | 10 | 0 | Always On: The local replica of availability group '%.*ls' is preparing to transition to the primary role. This is an informational message only. No user action is required. |
41075 | 10 | 0 | Always On: The local replica of availability group '%.*ls' is preparing to transition to the resolving role. This is an informational message only. No user action is required. |
41076 | 10 | 0 | Always On: Availability group '%.*ls' is going offline because it is being removed. This is an informational message only. No user action is required. |
41077 | 16 | 0 | Cannot bring the Windows Server Failover Clustering (WSFC) group (ID '%.*ls') online at this time. The WSFC group is not in a state that could accept the request. Please wait for the WSFC group to enter a terminal state and then retry the operation. For information about this error, see error code 5023 in "System Error Codes" in the Windows Development documentation. |
41078 | 16 | 0 | Failed to delete the Windows Server Failover Clustering (WSFC) registry value corresponding to name '%.*ls', because a registry entry with the specified name does not exist. Check that the registry value name is correct, and retry the operation. |
41079 | 16 | 0 | Cannot drop the Windows Server Failover Clustering (WSFC) group (ID or name '%.*ls'), because the WSFC group does not exist. Specify a valid WSFC group ID or name and retry the operation. For information about this error, see error code 5013 in "System Error Codes" in the Windows Development documentation. |
41080 | 16 | 0 | Failed to delete SQL Server instance name to Windows Server Failover Clustering node name map entry for the local availability replica of availability group '%.*ls'. The operation encountered SQL Server error %d and has been terminated. Refer to the SQL Server error log for details about this SQL Server error and corrective actions. |
41081 | 16 | 0 | Failed to destroy the Windows Server Failover Clustering group corresponding to availability group '%.*ls'. The operation encountered SQL Server error %d and has been terminated. Refer to the SQL Server error log for details about this SQL Server error and corrective actions. |
41082 | 16 | 0 | Failed to obtain the name of local Windows Server Failover Cluster (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41083 | 16 | 0 | Failed to obtain the cluster quorum resource (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41084 | 16 | 0 | The Windows Server Failover Clustering (WSFC) cluster control API returned error code %d. If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41085 | 16 | 0 | Failed to find a DWORD property (property name '%s') of the Windows Server Failover Clustering (WSFC) (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. Otherwise, contact your primary support provider. For information about this error code, see "System Error Codes" in the Windows Development documentation. |
41086 | 16 | 0 | Failed to retrieve the Paxos tag from the Windows Server Failover Clustering (WSFC) registry hive. The WSFC registry hive might be corrupt. Verify whether the 'HKLMClusterPaxosTag' registry value exists in the WSFC registry hive. |
41087 | 16 | 0 | Error in parsing the Paxos tag from the Windows Server Failover Clustering (WSFC) registry hive. The WSFC registry hive might be corrupt. Verify whether the 'HKLMClusterPaxosTag' is in the format outlined in the Microsoft Knowledge Base article KB 947713 ("The implications of using the /forcequorum switch to start the Cluster service in Windows Server 2008"). |
41088 | 16 | 0 | Failed to determine if the Windows Server Failover Clustering (WSFC) service is in Force Quorum state. The prerequisite hotfix, KB 2494036, might not yet be installed on your Windows Server 2008/Windows Server 2008 R2 systems. For more information, see Microsoft Knowledge Base article KB 2494036 ("A hotfix is available to let you configure a cluster node that does not have quorum votes in Windows Server 2008 and in Windows Server 2008 R2"). |
41089 | 10 | 1 | Always On Availability Groups startup has been cancelled, because SQL Server is shutting down. This is an informational message only. No user action is required. |
41090 | 10 | 0 | Failed to update Replica status due to exception %d. |
41091 | 10 | 0 | Always On: The local replica of availability group '%.*ls' is going offline because either the lease expired or lease renewal failed. This is an informational message only. No user action is required. |
41092 | 10 | 0 | Always On: The availability replica manager is going offline because %ls. This is an informational message only. No user action is required. |
41093 | 10 | 0 | Always On: The local replica of availability group '%.*ls' is going offline because the corresponding resource in the Windows Server Failover Clustering (WSFC) cluster is no longer online. This is an informational message only. No user action is required. |
41094 | 10 | 0 | Always On: The local replica of availability group '%.*ls' is restarting because the existing primary replica restarted or the availability group failed over to a new primary replica. This is an informational message only. No user action is required. |
41095 | 10 | 0 | Always On: Explicitly transitioning the state of the Windows Server Failover Clustering (WSFC) resource that corresponds to availability group '%.*ls' to Failed. The resource state is not consistent with the availability group state in the instance of SQL Server. The WSFC resource state indicates that the local availability replica is the primary replica, but the local replica is not in the primary role. This is an informational message only. No user action is required. |
41096 | 10 | 0 | Always On: The local replica of availability group '%.*ls' is being removed. The instance of SQL Server failed to validate the integrity of the availability group configuration in the Windows Server Failover Clustering (WSFC) store. This is expected if the availability group has been removed from another instance of SQL Server. This is an informational message only. No user action is required. |
41097 | 10 | 0 | Always On: The local replica of availability group '%.*ls' is going offline. This replica failed to read the persisted configuration because of a version mismatch. This is an informational message only. No user action is required. |
41098 | 10 | 0 | Always On: The local replica of availability group '%.*ls' is restarting, because it failed to read the persisted configuration. This is an informational message only. No user action is required. |
41099 | 10 | 0 | Always On: The local replica of availability group '%.*ls' is going offline. This replica failed to read the persisted configuration, and it has exhausted the maximum for restart attempts. This is an informational message only. No user action is required. |
41100 | 16 | 0 | The availability group '%.*ls' and/or its local availability replica does not exist. Verify that the specified availability group name is correct, and that the local availability replica has joined the availability group, then retry the operation. |
41101 | 16 | 0 | The availability group with Windows Server Failover Clustering resource ID '%.*ls' and/or its local availability replica does not exist. Verify that the specified availability resource ID is correct, and that the local availability replica has joined the availability group, then retry the operation. |
41102 | 10 | 0 | Failed to persist configuration data of availability group '%.*ls'. The local availability replica either is not the primary replica or is shutting down. |
41103 | 10 | 0 | Startup of the Always On Availability Replica Manager has been terminated, because the 'FixQuorum' property of Windows Server Failover Clustering (WSFC) is not present. The prerequisite Hotfix, KB 2494036, might not yet be installed on your Windows Server 2008/Windows Server 2008 R2 systems. For more information, see Microsoft Knowledge Base article KB 2494036 ("A hotfix is available to let you configure a cluster node that does not have quorum votes in Windows Server 2008 and in Windows Server 2008 R2"). |
41104 | 16 | 0 | Failover of the availability group '%.*ls' to the local replica failed because the availability group resource did not come online due to a previous error. To identify that error, check the SQL Server error log, cluster logs and system event logs. For information about how to view events and logs for a Windows Server Failover Clustering (WSFC) cluster, see Windows Server documentation. |
41105 | 16 | 0 | Failed to create the Windows Server Failover Clustering (WSFC) resource with name '%s' and type '%s'. The resource type is not registered in the WSFC cluster. The WSFC cluster many have been destroyed and created again. To register the resource type in the WSFC cluster, disable and then enable Always On in the SQL Server Configuration Manager. |
41106 | 16 | 0 | Cannot create an availability replica for availability group '%.*ls'. An availability replica of the specified availability group already exists on this instance of SQL Server. Verify that the specified availability group name is correct and unique, then retry the operation. To remove the existing availability replica, run DROP AVAILABILITY GROUP command. |
41107 | 16 | 0 | Availability group '%.*ls' failed to create necessary events for the WSFC Lease mechanism. Windows returned error code (%d) when obtaining handles for Lease events. Resolve the windows error and retry the availability group operation. |
41108 | 16 | 0 | An error occurred while removing availability group '%.*ls'. The DROP AVAILABILITY GROUP command removed the availability group configuration from the local metadata. However, the attempt to remove this configuration from the Windows Server Failover Clustering (WSFC) cluster failed because the Always On Availability Groups manager is not online (SQL Server error: %d). To remove the availability group configuration from the WSFC cluster, re-enter the command. |
41109 | 17 | 0 | Could not enqueue a task (SQL OS error: 0x%x) for process actions for the availability group '%.*ls'. Most likely, the instance of SQL Server is low on resources. Check the SQL Server error log to determine the cause of the failure. Retry the operation later, and if this condition persists, contact your database administrator. |
41110 | 10 | 0 | Always On: The availability replica manager is starting. This is an informational message only. No user action is required. |
41111 | 10 | 0 | Always On: The availability replica manager is waiting for the instance of SQL Server to allow client connections. This is an informational message only. No user action is required. |
41112 | 16 | 0 | A Windows Server Failover Clustering (WSFC) API required by availability groups has not been loaded. Always On Availability Groups replica manager is not enabled on the local instance SQL Server. If the server instance is running an edition of SQL Server that supports Always On Availability Groups, you can enable the it by using the SQL Server Configuration Manager. |
41113 | 16 | 0 | Cannot failover availability group '%.*ls' to this instance of SQL Server because a failover command is already pending on the local replica of this availability group. Wait for the pending failover command to complete before issuing another command on the local replica of this availability group. |
41114 | 16 | 0 | Cannot create an availability group named '%.*ls' because it already exists in a system table. |
41115 | 16 | 0 | Cannot create the availability group named '%.*ls' because its availability group ID (ID: '%.*ls') already exists in a system table.t |
41116 | 16 | 0 | Cannot create an availability group named '%.*ls' with replica ID '%.*ls' because this ID already exists in a system table.t |
41117 | 16 | 0 | Cannot map local database ID %d to the availability database ID '%.*ls' within availability group '%.*ls'. This database is already mapped to an availability group.t |
41118 | 16 | 0 | Cannot map database ID %d to the availability database ID '%.*ls' within availability group '%.*ls'. Another local database, (ID %d). is already mapped to this availability database.t |
41119 | 16 | 0 | Could not find the availability group ID %d in the system table.t |
41120 | 16 | 0 | Failed to start task to process a down notification for the local Windows Server Failover Clustering (WSFC) node (SQL OS error: %d). Possible causes are no worker threads are available or there is insufficient memory. Check the state of the local WSFC node. If this problem persists, you might need to restart the instance of SQL Server. |
41121 | 10 | 0 | The local availability replica of availability group '%.*ls' cannot accept signal '%s' in its current replica role, '%s', and state (configuration is %s in Windows Server Failover Clustering store, local availability replica has %s joined). The availability replica signal is invalid given the current replica role. When the signal is permitted based on the current role of the local availability replica, retry the operation. |
41122 | 16 | 0 | Cannot failover availability group '%.*ls' to this instance of SQL Server. The local availability replica is already the primary replica of the availability group. To failover this availability group to another instance of SQL Server, run the failover command on that instance of SQL Server. If local instance of SQL Server is intended to host the primary replica of the availability group, then no action is required. |
41123 | 16 | 0 | Cannot bring the Windows Server Failover Clustering (WSFC) group (ID '%.*ls') online at this time. The WSFC group is moving to another node. Please wait for the WSFC group to complete the move operation and then retry the command. For information about this error, see error code 5908 in "System Error Codes" in the Windows Development documentation. |
41124 | 16 | 0 | The availability replica for availability group '%.*ls' on this instance of SQL Server cannot become the primary replica because the availability group is being dropped. |
41125 | 16 | 0 | The availability replica for availability group '%.*ls' on this instance of SQL Server cannot become the primary replica because the WSFC cluster was started in Force Quorum mode. Consider performing a forced manual failover (with possible data loss). |
41126 | 16 | 0 | Operation on the local availability replica of availability group '%.*ls' failed. The local copy of the availability group configuration does not exist or has not been initialized. Verify that the availability group exists and that the local copy of the configuration is initialized, and retry the operation. |
41127 | 16 | 0 | Attempt to set database mapping state where the local database id %d is not mapped to any availability group. |
41128 | 16 | 0 | Failed to perform database operation '%s' on database '%.*ls' (ID %d) in availability group '%.*ls'. The database might be in an incorrect state for the operation. If the problem persists, you may need to restart the SQL Server instance. |
41129 | 16 | 0 | Failed to schedule or execute database operation '%s' on database '%.*ls' (Database ID: %d) in availability group '%.*ls' (SQL OS error: %d). The instance of SQL Server may have insufficient resources to carry out the database operation. If the problem persists, you might need to restart the server instance. |
41130 | 16 | 0 | Operation '%s' on a database '%.*ls' (Database ID: %d) in availability group '%.*ls' failed with SQL Server error %d (Error details: "%.*ls"). The operation has been rolled back. See previous error messages in the SQL Server error log for more details. If the problem persists, you might need to restart the instance of SQL Server. |
41131 | 10 | 0 | Failed to bring availability group '%.*ls' online. The operation timed out. If this is a Windows Server Failover Clustering (WSFC) availability group, verify that the local WSFC node is online. Then verify that the availability group resource exists in the WSFC cluster. If the problem persists, you might need to drop the availability group and create it again. |
41132 | 16 | 0 | Cannot join database '%.*ls' to availability group '%.*ls'. The specified database does not belong to the availability group. Verify the names of the database and the availability group, and retry the command specifying the correct names. |
41133 | 10 | 0 | Cannot remove database '%.*ls' from availability group '%.*ls'. Either the database does not belong to the availability group, or the database has not joined the group. Verify the database and availability group names, and retry the command. |
41134 | 16 | 0 | Cannot bring the availability group '%.*ls' online. The local instance was not the previous primary replica when the availability group went offline, not all databases are synchronized, and no force failover command was issued on the local availability replica. To designate the local availability replica as the primary replica of the availability group, run the force failover command on this instance of SQL Server. |
41135 | 10 | 0 | Startup of Always On Availability Groups replica manager failed due to SQL Server error %d. To determine the cause of this error, check the SQL Server error log for the preceding error. |
41136 | 16 | 0 | Failed to join the availability replica to availability group '%.*ls' because the group is not online. Either bring the availability group online, or drop and recreate it. Then retry the join operation. |
41137 | 10 | 0 | Abandoning a database operation '%ls' on availability database '%.*ls' of availability group '%.*ls'. The sequence number of local availability replica has changed (Previous sequence number: %u, current sequence number: %u). This is an informational message only. No user action is required. |
41138 | 17 | 0 | Cannot accept Always On Availability Groups operation operation on database '%.*ls' of availability group '%.*ls'. The database is currently processing another operation that might change the database state. Retry the operation later. If the condition persists, contact the database administrator. |
41139 | 10 | 0 | Failed to set database information for availability group %.*ls. The local availability replica is not the primary replica, or it is shutting down. This is an informational message only. No user action is required. |
41140 | 16 | 0 | Availability group '%.*ls' cannot process the ALTER AVAILABILITY GROUP command, because the local availability replica is not the primary replica. Connect to the server instance that is currently hosting the primary replica of this availability group, and rerun the command. |
41141 | 16 | 0 | Failed to set availability group database information for availability group %.*ls. The local availability replica is not the primary, or is shutting down. This is an informational message only. No user action is required. |
41142 | 16 | 0 | The availability replica for availability group '%.*ls' on this instance of SQL Server cannot become the primary replica. One or more databases are not synchronized or have not joined the availability group. If the availability replica uses the asynchronous-commit mode, consider performing a forced manual failover (with possible data loss). Otherwise, once all local secondary databases are joined and synchronized, you can perform a planned manual failover to this secondary replica (without data loss). For more information, see SQL Server Books Online. |
41143 | 16 | 0 | Cannot process the operation. The local replica of availability Group '%.*ls' is in a failed state. A previous operation to read or update persisted configuration data for the availability group has failed. To recover from this failure, either restart the local Windows Server Failover Clustering (WSFC) service or restart the local instance of SQL Server. |
41144 | 16 | 0 | The local availability replica of availability group '%.*ls' is in a failed state. The replica failed to read or update the persisted configuration data (SQL Server error: %d). To recover from this failure, either restart the local Windows Server Failover Clustering (WSFC) service or restart the local instance of SQL Server. |
41145 | 10 | 0 | Cannot join database '%.*ls' to availability group '%.*ls'. The database has already joined the availability group. This is an informational message. No user action is required. |
41146 | 16 | 0 | Failed to bring Availability Group '%.*ls' online. If this is a WSFC availability group, the Windows Server Failover Clustering (WSFC) service may not be running, or it may not be accessible in its current state. Please verify the local WSFC node is up and then retry the operation. Otherwise, contact your primary source provider. |
41147 | 10 | 0 | Always On Availability Groups was not started because %ls. This is an informational message. No user action is required. |
41148 | 16 | 0 | Cannot add or join database '%.*ls' to availability group '%.*ls'. The database does not exist on this instance of SQL Server. Verify the database name and that the database exists on the server instance. Then retry the operation, specifying the correct database name. |
41149 | 16 | 0 | Operation on the availability group '%.*ls' has been cancelled or terminated, either because of a connection timeout or cancellation by user. This is an informational message. No user action is required. |
41150 | 16 | 0 | Failed to take availability group '%.*ls' offline. If this is a WSFC availability group, the Windows Server Failover Clustering (WSFC) service may not be running, or it may not be accessible in its current state. Verify the local WSFC node is up and then retry the operation. Otherwise, contact your primary support provider. |
41151 | 16 | 0 | Error accessing the Availability Groups manager. The local Availability Groups manager has not been initialized. Wait until the Availability Groups manager is in a state that allows access, and retry the operation. |
41152 | 16 | 0 | Failed to create availability group '%.*ls'. The operation encountered SQL Server error %d and has been rolled back. Check the SQL Server error log for more details. When the cause of the error has been resolved, retry CREATE AVAILABILITY GROUP command. |
41153 | 16 | 0 | Failed to create availability group '%.*ls'. The operation encountered SQL Server error %d. An attempt to roll back the operation failed. Check the SQL Server error log for more details. Then execute the DROP AVAILABILITY GROUP command to clean up any metadata that might remain from the failed attempt to create the availability group. |
41154 | 16 | 0 | Cannot failover availability group '%.*ls' to this SQL Server instance. The availability group is still being created. Verify that the specified availability group name is correct. Wait for CREATE AVAILABILITY GROUP command to finish, then retry the operation. |
41155 | 16 | 0 | Cannot failover availability group '%.*ls' to this instance of SQL Server. The availability group is being dropped. Verify that the specified availability group name is correct. The availability group may need to be recreated if the drop operation was unintentional. |
41156 | 16 | 0 | Cannot drop availability group '%.*ls' from this instance of SQL Server. The availability group is either being dropped, or the local availability replica is being removed from the availability group. Verify that the specified availability group name is correct. Wait for the current operation to complete, then retry the command if necessary. |
41157 | 16 | 0 | Cannot remove the local availability replica from availability group '%.*ls' from this instance of SQL Server. The availability group is either being dropped, or the local availability replica is being disjoined. Verify that the specified availability group name is correct. Wait for the current operation to complete, then retry the command if necessary. |
41158 | 16 | 0 | Failed to join local availability replica to availability group '%.*ls'. The operation encountered SQL Server error %d and has been rolled back. Check the SQL Server error log for more details. When the cause of the error has been resolved, retry the ALTER AVAILABILITY GROUP JOIN command. |
41159 | 16 | 0 | Failed to join local availability replica to availability group '%.*ls'. The operation encountered SQL Server error %d. An attempt to rollback the operation failed. Check SQL Server error log for more details. Run DROP AVAILABILITY GROUP command to clean up any metadata that might remain from the availability group. |
41160 | 16 | 0 | Failed to designate the local availability replica of availability group '%.*ls' as the primary replica. The operation encountered SQL Server error %d and has been terminated. Check the preceding error and the SQL Server error log for more details about the error and corrective actions. |
41161 | 16 | 0 | Failed to validate the Cyclic Redundancy Check (CRC) of the configuration of availability group '%.*ls'. The operation encountered SQL Server error %d, and the availability group has been taken offline to protect its configuration and the consistency of its joined databases. Check the SQL Server error log for more details. If configuration data corruption occurred, the availability group might need to be dropped and recreated. |
41162 | 16 | 0 | Failed to validate sequence number of the configuration of availability group '%.*ls'. The in-memory sequence number does not match the persisted sequence number. The availability group and/or the local availability replica will be restarted automatically. No user action is required at this time. |
41163 | 16 | 0 | An error occurred while waiting for the local availability replica of availability group '%.*ls' to transition to the primary role. The operation encountered SQL OS error %d and has been terminated. Verify that the availability group is in the correct state for the command. If this is a Windows Server Failover Clustering (WSFC) availability group, also verify that the WSFC cluster is in the correct state for the command. Then retry the command. |
41164 | 16 | 0 | An error occurred while waiting for the local availability replica of availability group '%.*ls' to transition to the resolving role. The operation encountered SQL OS error %d and has been terminated. Verify that the availability group is in the correct state for the command. If this is a Windows Server Failover Clustering (WSFC) availability group, also verify that the WSFC cluster is in the correct state for the command. Then retry the command. |
41165 | 16 | 0 | A timeout error occurred while waiting to access the local availability replica of availability group '%.*ls'. The availability replica is currently being accessed by another operation. Wait for the in-progress operation to complete, and then retry the command. |
41166 | 16 | 0 | An error occurred while waiting to access the local availability replica of availability group '%.*ls'. The operation encountered SQL OS error %d, and has been terminated. Verify that the local availability replica is in the correct state, and then retry the command. |
41167 | 16 | 0 | An error occurred while attempting to access availability replica '%.*ls' in availability group '%.*ls'. The availability replica is not found in the availability group configuration. Verify that the availability group and availability replica names are correct, then retry the command. |
41168 | 16 | 0 | An error occurred while attempting to access availability replica with ID '%.*ls' in availability group '%.*ls'. The availability replica is not found in the availability group configuration. Verify that the availability group name and availability replica ID are correct, then retry the command. |
41169 | 16 | 0 | An error occurred while attempting to access the availability group database with ID '%.*ls' in availability group '%.*ls'. The availability database is not found in the availability group configuration. Verify that the availability group name and availability database ID are correct, then retry the command. |
41170 | 10 | 0 | Post-online processing for availability group '%.*ls' has been terminated. Either post-online processing has already completed, the local availability replica is no longer the primary replica, or the availability group is being dropped. This is an informational message. No user action is required. |
41171 | 16 | 0 | Failed to create availability group '%.*ls', because a Windows Server Failover Cluster (WSFC) group with the specified name already exists. The operation has been rolled back successfully. To retry creating an availability group, either remove or rename the existing WSFC group, or retry the operation specifying a different availability group name. |
41172 | 16 | 0 | An error occurred while dropping availability group '%.*ls'. The operation encountered SQL OS error %d, and has been terminated. Verify that the specified availability group name is correct, and then retry the command. |
41173 | 16 | 0 | An error occurred while removing the local availability replica from availability group '%.*ls'. The operation encountered SQL OS error %d, and has been terminated. Verify that the specified availability group name is correct, and then retry the command. |
41174 | 10 | 0 | Failed to start the task of the Windows Server Failover Clustering (WSFC) event notification worker (SQL OS error: %d). If the problem persists, you might need to restart the instance of SQL Server. |
41175 | 10 | 0 | Failed to stop the task of WSFC event notification worker (SQL OS error: %d). If the problem persists, you might need to restart the instance of SQL Server. |
41176 | 10 | 0 | Failed to acquire exclusive access to local availability group configuration data (SQL OS error: %d). If the problem persists, you might need to restart the instance of SQL Server. |
41177 | 16 | 0 | The availability replica of the specified availability group '%.*ls' is being dropped. Wait for the completion of the drop command and retry the operation later. |
41178 | 16 | 0 | Cannot drop availability group '%.*ls' from this SQL Server instance. The availability group is currently being created. Verify that the specified availability group name is correct. Wait for the current operation to complete, then retry the command if necessary. |
41179 | 16 | 0 | Cannot remove the local availability replica from availability group '%.*ls' from this instance of SQL Server. The availability group is currently being created. Verify that the specified availability group name is correct. Wait for the current operation to complete, and then retry the command if necessary. |
41180 | 16 | 0 | Attempt to access non-existent or uninitialized availability group with ID '%.*ls'. This is usually an internal condition, such as the availability group is being dropped or the local WSFC node has lost quorum. In such cases, and no user action is required. |
41181 | 16 | 0 | The local availability replica of availability group '%.*ls' did not become primary. A concurrent operation may have changed the state of the availability group in Windows Server Failover Cluster. Verify that the availability group state in Windows Server Failover Cluster is correct, then retry the operation. |
41182 | 16 | 0 | Failed to set the local availability replica of availability group '%.*ls' as joined in Windows Server Failover Clustering (WSFC) database. Either the local availability replica is no longer the primary, or the WSFC service is not accessible. Verify that the local WSFC node is online, and that the local availability replica is the primary replica. Then retry the operation. |
41183 | 16 | 0 | Failed to modify availability replica options for availability group '%.*ls'. Before the availability group configuration could be updated, the operation encountered SQL Server error %d. The operation has been rolled back. Refer to the SQL Server error log for more information. If this is a Windows Server Failover Clustering (WSFC) availability group, verify that the local WSFC node is online, and retry the command. Otherwise, contact your primary support provider. |
41184 | 16 | 0 | Failed to modify availability replica options for availability group '%.*ls'. The availability group configuration has been updated. However, the operation encountered SQL Server error %d while applying the new configuration to the local availability replica. The operation has been terminated. Refer to the SQL Server error log for more information. If this is a Windows Server Failover Clustering (WSFC) availability group, verify that the local WSFC node is online. Use the ALTER AVAILABILITY GROUP command to undo the changes made to the availability group configuration. |
41185 | 10 | 0 | Replica option specified in ALTER AVAILABILITY GROUP '%.*ls' MODIFY DDL is same is cached availability group configuration. |
41186 | 16 | 0 | Availability group '%.*ls' cannot process an ALTER AVAILABILITY GROUP command at this time. The availability group is still being created. Verify that the specified availability group name is correct. Wait for CREATE AVAILABILITY GROUP command to finish, and then retry the operation. |
41187 | 16 | 0 | Availability group '%.*ls' cannot process an ALTER AVAILABILITY GROUP command at this time. The availability group is being dropped. Verify that the specified availability group name is correct. The availability group may need to be recreated if it was dropped unintentionally. |
41188 | 16 | 0 | Availability group '%.*ls' failed to process %s-%s command. The operation encountered SQL Server error %d before the availability group configuration could be updated, and has been rolled back. Refer to the SQL Server error log for details. If this is a Windows Server Failover Clustering (WSFC) availability group, verify that the local WSFC node is online, and then retry the command. Otherwise, contact your primary support provider. |
41189 | 16 | 0 | Availability group '%.*ls' failed to process the %s-%s command. The availability group configuration has been updated. However, the operation encountered SQL Server error %d while applying the new configuration to the local availability replica, and has been terminated. Refer to the SQL Server error log for details . If this is a Windows Server Failover Clustering (WSFC) availability group, verify that the local WSFC node is online. Use an ALTER AVAILABILITY GROUP command to undo the changes to the availability group configuration. |
41190 | 16 | 0 | Availability group '%.*ls' failed to process %s-%s command. The local availability replica is not in a state that could process the command. Verify that the availability group is online and that the local availability replica is the primary replica, then retry the command. |
41191 | 16 | 0 | The local availability replica of availability group '%.*ls' cannot become the primary replica. The last-known primary availability replica is of a higher version than the local availability replica. Upgrade the local instance of SQL Server to the same or later version as the server instance that is hosting the current primary availability replica, and then retry the command. |
41192 | 17 | 0 | Creating and scheduling a worker task for Always On Availability Groups failed due to lack of resources (SQL OS error %d). Processing of new actions might be delayed or stalled until the resource limits are resolved. Reduce the memory or thread count on the instance of SQL Server to allow new threads to get scheduled. If new tasks are scheduled the problem might resolve itself. However, if the problem persists, you might need to restart the local instance of SQL Server. |
41193 | 10 | 0 | Cannot join database '%.*ls' to availability group '%.*ls'. The database is in the process of being removed from the availability group. When the remove-database operation completes, the database will no longer be joined to the availability group. Then retry the join-database command. |
41194 | 16 | 0 | An error occurred while waiting for the local availability replica for availability group '%.*ls' to complete post-online work. The operation encountered SQL OS error %d and has been terminated. Verify that the availability group is in the correct state for the command. If this is a Windows Server Failover Clustering (WSFC) availability group, also verify that the WSFC cluster is in the correct states for the command. Then retry the command. |
41195 | 16 | 0 | Availability group '%.*ls' failed to process the WSFC lease-renewal command. The local availability replica lease is no longer valid to process the lease renewal command. Availability replica lease expired. This is an informational message only. No user action is required. |
41196 | 16 | 0 | Failed to create availability group '%.*ls', because a Windows Server Failover Cluster (WSFC) group with the specified name already exists. An attempt to rollback the operation failed. Check the SQL Server error log for more details. To manually clean up the partially created availability group, run the DROP AVAILABILITY GROUP command. Reenter your CREATE AVAILABILITY GROUP command specifying a unique availability group name. |
41197 | 15 | 0 | The FAILOVER_MODE option has not been specified for the replica '%.*ls'. Reenter the command, specifying a failover mode for the replica. |
41198 | 15 | 0 | The AVAILABILITY_MODE option has not been specified for the replica '%.*ls'. Reenter the command, specifying an availability mode for the replica. |
41199 | 16 | 0 | The specified command is invalid because the Always On Availability Groups %ls feature is not supported by this edition of SQL Server. For information about features supported by the editions of SQL Server, see SQL Server Books Online. |
41201 | 16 | 0 | The SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE and SEMANTICSIMILARITYDETAILSTABLE functions do not support remote data sources. |
41202 | 16 | 0 | The source table '%.*ls' specified in the SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE or SEMANTICSIMILARITYDETAILSTABLE function doesn't have a full-text index that uses the STATISTICAL_SEMANTICS option. A full-text index using the STATISTICAL_SEMANTICS option is required to use this function. |
41203 | 16 | 0 | The column '%.*ls' specified in the SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE or SEMANTICSIMILARITYDETAILSTABLE function is not full-text indexed with the STATISTICAL_SEMANTICS option. The column must be full-text indexed using the STATISTICAL_SEMANTICS option to be used in this function. |
41204 | 16 | 0 | The source_key parameter is required in the SEMANTICSIMILARITYTABLE function. |
41205 | 10 | 0 | Error %d occurred during semantic index population for table or indexed view '%.*ls' (table or indexed view ID %d, database ID %d, document ID %d) |
41206 | 10 | 0 | An ALTER FULLTEXT INDEX statement cannot remove the 'STATISTICAL_SEMANTICS' option from the last column in the index that has the option set when a "WITH NO POPULATION" clause is specified. Remove the "WITH NO POPULATION" clause. |
41207 | 10 | 0 | A locale ID that is not supported was specified for a column with 'STATISTICAL_SEMANTICS'. Please verify that the locale ID is correct and that the corresponding language statistics has been installed. |
41208 | 10 | 0 | Warning: The population for table or indexed view '%ls' (table or indexed view ID '%d', database ID '%d') encountered a document with full-text key value '%ls' that specifies a language not supported for semantic indexing. Some columns of the row will not be part of the semantic index. |
41209 | 10 | 0 | A semantic language statistics database is not registered. Full-text indexes using 'STATISTICAL_SEMANTICS' cannot be created or populated. |
41210 | 10 | 0 | The semantic language statistics database is not accessible or not valid. Full-text indexes using 'STATISTICAL_SEMANTICS' cannot be created or populated. |
41211 | 16 | 0 | A semantic language statistics database is already registered. |
41212 | 16 | 0 | No semantic language statistics database is registered. |
41213 | 16 | 0 | The database '%.*ls' does not exist or the database format is not valid. Provide a valid semantic language statistics database name. |
41214 | 16 | 0 | An error occurred while trying to register the semantic language statistics database. |
41215 | 16 | 0 | The SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE and SEMANTICSIMILARITYDETAILSTABLE functions do not support update or insert. |
41300 | 16 | 0 | The current transaction cannot be committed and cannot support read or write operations. Roll back the transaction. |
41301 | 17 | 0 | A transaction dependency failure occurred, and the current transaction can no longer commit. Please retry the transaction. |
41302 | 16 | 0 | The current transaction attempted to update a record that has been updated since this transaction started. The transaction was aborted. |
41303 | 16 | 0 | The bucket count for a hash index must be a positive integer not exceeding %d. |
41304 | 10 | 0 | The current value of option '%.*ls' for table '%.*ls', index '%.*ls' is %d. |
41305 | 17 | 0 | The current transaction failed to commit due to a repeatable read validation failure. |
41306 | 16 | 0 | The nesting limit of %d for conditional blocks and exception blocks, for natively compiled modules, has been exceeded. Please simplify the module. |
41307 | 16 | 0 | The row size limit of %d bytes for memory optimized tables has been exceeded. Please simplify the table definition. |
41308 | 21 | 0 | The database ID %d already exists. |
41309 | 16 | 0 | Unable to load the compiled DLL for database ID %d. |
41310 | 16 | 0 | A file with an invalid format was detected. Check the SQL Server error log for more details. |
41311 | 16 | 0 | File error during C code generation. The error code was %d. |
41312 | 16 | 0 | Unable to call into the C compiler. GetLastError = %d. |
41313 | 16 | 0 | The C compiler encountered a failure. The exit code was %d. |
41314 | 16 | 0 | Conversion of default value for parameter '%.*ls' failed. Unable to create stored procedure '%.*ls'. |
41315 | 16 | 0 | Checkpoint operation failed in database '%.*ls'. |
41316 | 16 | 0 | Restore operation failed for database '%.*ls' with internal error code '0x%08lx'. |
41317 | 16 | 0 | A user transaction that accesses memory optimized tables or natively compiled modules cannot access more than one user database or databases model and msdb, and it cannot write to master. |
41318 | 16 | 0 | Memory optimized tables and natively compiled modules cannot be accessed from within SQLCLR stored procedures. |
41319 | 16 | 0 | A maximum of %d predicates are allowed in the WHERE clauses of queries in natively compiled modules. |
41320 | 16 | 0 | EXECUTE AS clause is required, and EXECUTE AS CALLER is not supported, with natively compiled modules. |
41321 | 16 | 0 | The memory optimized table '%.*ls' with DURABILITY=SCHEMA_AND_DATA must have a primary key. |
41322 | 16 | 0 | MAT/PIT export/import encountered a failure for memory optimized table or natively compiled module with object ID %d in database ID %d. The error code was 0x%x. |
41323 | 16 | 0 | The table type '%ls' is not a memory optimized table type and cannot be used in a natively compiled module. |
41324 | 16 | 0 | The memory optimized table variable '%.*ls' cannot be used in a batch with a 'USE' statement. |
41325 | 17 | 0 | The current transaction failed to commit due to a serializable validation failure. |
41326 | 16 | 0 | Memory optimized tables cannot be created in system databases. |
41327 | 16 | 0 | The memory optimized table '%.*ls' must have at least one index or a primary key. |
41328 | 16 | 0 | A floating point operation has overflowed. |
41329 | 16 | 0 | Unsupported operation following a transaction dependency failure. Parameters and variables cannot be accessed in the CATCH block and the CATCH block must raise an exception following a dependency failure. |
41330 | 16 | 0 | Create database operation failed for database '%.*ls'. |
41331 | 17 | 0 | The transaction encountered an out-of-memory condition while rolling back to a savepoint, and therefore cannot be committed. Roll back the transaction. |
41332 | 16 | 0 | Memory optimized tables and natively compiled modules cannot be accessed or created when the session TRANSACTION ISOLATION LEVEL is set to SNAPSHOT. |
41333 | 16 | 0 | The following transactions must access memory optimized tables and natively compiled modules under snapshot isolation: RepeatableRead transactions, Serializable transactions, and transactions that access tables that are not memory optimized in RepeatableRead or Serializable isolation. |
41334 | 16 | 0 | The code generation directory cannot be created or set up correctly. |
41335 | 16 | 0 | Modifying the collation of a database is not allowed when the database contains memory optimized tables or natively compiled modules. |
41337 | 16 | 0 | Cannot create %S_MSG. To create %S_MSG, the database must have a MEMORY_OPTIMIZED_FILEGROUP that is online and has at least one container. |
41338 | 16 | 0 | An invalid version of a data file was detected. Check the SQL Server error log for more details. |
41339 | 16 | 0 | The table '%.*ls' has been created or altered after the start of the current transaction. The transaction was aborted. Please retry the transaction. |
41340 | 16 | 0 | The transaction executed too many insert, update, or delete statements in memory optimized tables. The transaction was terminated. |
41341 | 16 | 0 | Table '%.*ls' is not yet available on the secondary replica. |
41342 | 16 | 0 | The model of the processor on the system does not support creating %.*ls. This error typically occurs with older processors. See SQL Server Books Online for information on supported models. |
41343 | 16 | 0 | In-Memory OLTP hot switch to primary replica for database '%.*ls' failed. |
41344 | 16 | 0 | RESTORE DATABASE WITH PARTIAL requires the MEMORY_OPTIMIZED_DATA filegroup if the backup contains a MEMORY_OPTIMIZED_DATA filegroup. |
41345 | 16 | 0 | The key size limit of %d bytes for nonclustered indexes on memory optimized tables has been exceeded. Please simplify the index definition. |
41346 | 16 | 0 | CREATE and UPDATE STATISTICS for memory optimized tables do not support the WHERE clause. |
41347 | 16 | 0 | A BACKUP or RESTORE DATABASE statement that includes the primary filegroup must include the MEMORY_OPTIMIZED_DATA filegroup, and vice versa. |
41348 | 16 | 0 | MEMORY_OPTIMIZED_DATA filegroups cannot be used with the FILESTREAM_ON clause. Specify a FILESTREAM filegroup. |
41349 | 10 | 0 | Warning: Encryption was enabled for a database that contains one or more memory optimized tables with durability SCHEMA_AND_DATA. The data in these memory optimized tables will not be encrypted. |
41350 | 10 | 0 | Warning: A memory optimized table with durability SCHEMA_AND_DATA was created in a database that is enabled for encryption. The data in the memory optimized table will not be encrypted. |
41351 | 16 | 0 | An error occurred while processing the log. The log version is unsupported. |
41352 | 16 | 0 | The operation on database ID %d cannot complete because the database is in use. |
41353 | 16 | 0 | The operation on database ID %d cannot complete because the database is being dropped or being taken offline. |
41354 | 21 | 1 | The XTP background checkpoint thread encountered an unrecoverable error ('%ls') for database '%.*ls'. The checkpoint process is terminating so that the thread can clean up its resources. This is an informational message only. No user action is required. |
41355 | 21 | 1 | An XTP checkpoint operation encountered an error ('%ls') while processing log record ID %S_LSN for database '%.*ls'. Checkpoint processing has terminated. |
41356 | 16 | 0 | Filegroups with MEMORY_OPTIMIZED_DATA can only be created in 64-bit installations of SQL Server. |
41357 | 16 | 0 | Tables with MEMORY_OPTIMIZED=ON can only be created in 64-bit installations of SQL Server. |
41358 | 16 | 0 | Stored procedures with NATIVE_COMPILATION can only be created in 64-bit installations of SQL Server. |
41359 | 16 | 0 | A query that accesses memory optimized tables using the READ COMMITTED isolation level, cannot access disk based tables when the database option READ_COMMITTED_SNAPSHOT is set to ON. Provide a supported isolation level for the memory optimized table using a table hint, such as WITH (SNAPSHOT). |
41360 | 16 | 0 | Default MEMORY_OPTIMIZED_DATA filegroup is not available in database '%.*ls'. |
41361 | 16 | 0 | The READ_ONLY property of a MEMORY_OPTIMIZED_DATA filegroup cannot be modified. |
41362 | 16 | 0 | FILESTREAM container '%.*ls' cannot be added. Either the server is out of memory or the container path is too long. |
41363 | 16 | 0 | Only the owner of database '%.*ls' or users with valid permission can execute the stored procedure '%.*ls'. |
41364 | 16 | 0 | Stored procedure '%.*ls' can only be executed on a database that has an online MEMORY_OPTIMIZED_DATA filegroup. |
41365 | 16 | 0 | Merge request for transaction range [%ld, %ld] on database '%.*ls' was not scheduled. The checkpoint files represented by the range either cannot be merged, or the checkpoint files are already part of an existing merge operation. |
41366 | 16 | 0 | Merge operation failed because the requested transaction id range is invalid. |
41367 | 16 | 0 | Failed to complete merge operation for transaction range [%ld, %ld] for database '%.*ls'. Error was 0x%08x. |
41368 | 16 | 0 | Accessing memory optimized tables using the READ COMMITTED isolation level is supported only for autocommit transactions. It is not supported for explicit or implicit transactions. Provide a supported isolation level for the memory optimized table using a table hint, such as WITH (SNAPSHOT). |
41369 | 16 | 0 | Merge operations cannot be requested on a secondary replica. |
41370 | 16 | 0 | Resource pool '%.*ls' does not exist or resource governor has not been reconfigured. |
41371 | 16 | 0 | Binding to a resource pool is not supported for system database '%.*ls'. This operation can only be performed on a user database. |
41372 | 16 | 0 | Database '%.*ls' is currently bound to a resource pool. A database must be unbound before creating a new binding. |
41373 | 16 | 0 | Database '%.*ls' cannot be explicitly bound to the resource pool '%.*ls'. A database can only be bound to a user resource pool. |
41374 | 16 | 0 | Database '%.*ls' does not have a binding to a resource pool. |
41375 | 16 | 0 | A binding has been created. Take database '%.*ls' offline and then bring it back online to begin using resource pool '%.*ls'. |
41376 | 16 | 0 | Only members of the fixed sysadmin role can execute the stored procedure '%ls'. |
41377 | 16 | 0 | The natively compiled module with database ID %ld and object ID %ld has not been executed. Query execution statistics collection can only be enabled if the module has been executed at least once since creation or last database restart. |
41378 | 16 | 0 | Both @database_id and @xtp_object_id should be specified to enable or retrieve status of query level statistics collection for a procedure. |
41379 | 16 | 0 | Restore operation failed for database '%.*ls' due to insufficient memory in the resource pool '%ls'. Close other applications to increase the available memory, ensure that both SQL Server memory configuration and resource pool memory limits are correct and try again. See 'http://go.microsoft.com/fwlink/?LinkID=507574' for more information. |
41380 | 21 | 0 | Databases with a MEMORY_OPTIMIZED_DATA filegroup are only supported in 64-bit editions of SQL Server. |
41381 | 21 | 0 | The database cannot be started in this edition of SQL Server because it contains a MEMORY_OPTIMIZED_DATA filegroup. See Books Online for more details on feature support in different SQL Server editions. |
41382 | 16 | 0 | Failure adding a container to a MEMORY_OPTIMIZED_DATA filegroup. Possible causes include the server being out of memory and the container path being too long. |
41383 | 16 | 0 | An internal error occurred while running the DMV query. This was likely caused by concurrent DDL operations. Please retry the query. |
41384 | 16 | 0 | Database '%.*ls' has exceeded the maximum number of XTP checkpoint files, and can no longer support write operations in durable memory-optimized tables. For more information, contact Customer Support Services. |
41385 | 16 | 0 | A database cannot be enabled for both Change Data Capture (CDC) and have memory-optimized tables at the same time. |
41386 | 16 | 0 | Filegroups with MEMORY_OPTIMIZED_DATA, memory-optimized tables and natively compiled modules are not supported when lightweight pooling is enabled. Disable lightweight pooling in order to use memory-optimized features. |
41387 | 10 | 0 | Disallowing page allocations for database '%.*ls' due to insufficient memory in the resource pool '%ls'. See 'http://go.microsoft.com/fwlink/?LinkId=510837' for more information. |
41388 | 16 | 0 | An upgrade operation failed for database '%.*ls'. Check the error log for additional details. |
41389 | 16 | 0 | Failed to create a backup file collection snapshot necessary for backup of database '%.*ls'. Check the error log for additional details. |
41390 | 16 | 0 | Failed to get checkpoint file information necessary for backup of database '%.*ls'. Check the error log for additional details. |
41391 | 23 | 0 | Backup of database '%.*ls' detected a missing MEMORY_OPTIMIZED_DATA file with ID '%.*ls'. |
41392 | 16 | 0 | Cannot ALTER a natively compiled module into a non-native module. Include WITH NATIVE_COMPILATION or drop and recreate the module. |
41393 | 16 | 0 | Cannot ALTER a non-native module into a natively compiled module. Omit WITH NATIVE_COMPILATION or drop and recreate the module. |
41394 | 16 | 0 | TEXTSIZE must be a number between -1 and 2147483647. |
41395 | 10 | 0 | Rebuilding the log file is not supported for databases containing memory-optimized tables. |
41396 | 16 | 0 | The sort operation exceeded the buffer limit. The stored procedure execution was aborted. Consult SQL Server Books Online for more information. |
41397 | 16 | 0 | The TOP operator can return a maximum of %d sorted rows. %d was requested. Reduce the number of rows selected or simplify the query. |
41398 | 16 | 0 | The TOP operator can return a maximum of %d rows; %d was requested. |
41399 | 16 | 0 | The sort operation is too complex. Consult SQL Server Books Online for more information. |
41401 | 16 | 0 | WSFC cluster service is offline. |
41402 | 16 | 0 | The WSFC cluster is offline, and this availability group is not available. This issue can be caused by a cluster service issue or by the loss of quorum in the cluster. |
41403 | 16 | 0 | Availability group is offline. |
41404 | 16 | 0 | The availability group is offline, and is unavailable. This issue can be caused by a failure in the server instance that hosts the primary replica or by the WSFC availability group resource going offline. |
41405 | 16 | 0 | Availability group is not ready for automatic failover. |
41406 | 16 | 0 | The availability group is not ready for automatic failover. The primary replica and a secondary replica are configured for automatic failover, however, the secondary replica is not ready for an automatic failover. Possibly the secondary replica is unavailable, or its data synchronization state is currently not in the SYNCHRONIZED synchronization state. |
41407 | 16 | 0 | Some availability replicas are not synchronizing data. |
41408 | 16 | 0 | In this availability group, at least one secondary replica has a NOT SYNCHRONIZING synchronization state and is not receiving data from the primary replica. |
41409 | 16 | 0 | Some synchronous replicas are not synchronized. |
41410 | 16 | 0 | In this availability group, at least one synchronous replica is not currently synchronized. The replica synchronization state could be either SYNCHONIZING or NOT SYNCHRONIZING. |
41411 | 16 | 0 | Some availability replicas do not have a healthy role. |
41412 | 16 | 0 | In this availability group, at least one availability replica does not currently have the primary or secondary role. |
41413 | 16 | 0 | Some availability replicas are disconnected. |
41414 | 16 | 0 | In this availability group, at least one secondary replica is not connected to the primary replica. The connected state is DISCONNECTED. |
41415 | 16 | 0 | Availability replica does not have a healthy role. |
41416 | 16 | 0 | The role of this availability replica is unhealthy. The replica does not have either the primary or secondary role. |
41417 | 16 | 0 | Availability replica is disconnected. |
41418 | 16 | 0 | This secondary replica is not connected to the primary replica. The connected state is DISCONNECTED. |
41419 | 16 | 0 | Data synchronization state of some availability database is not healthy. |
41420 | 16 | 0 | At least one availability database on this availability replica has an unhealthy data synchronization state. If this is an asynchronous-commit availability replica, all availability databases should be in the SYNCHRONIZING state. If this is a synchronous-commit availability replica, all availability databases should be in the SYNCHRONIZED state. |
41421 | 16 | 0 | Availability database is suspended. |
41422 | 16 | 0 | Either a database administrator or the system has suspended data synchronization on this availability database. |
41423 | 16 | 0 | Secondary database is not joined. |
41424 | 16 | 0 | This secondary database is not joined to the availability group. The configuration of this secondary database is incomplete. For information about how to join a secondary database to an availability group, see SQL Server Books Online. |
41425 | 16 | 0 | Data synchronization state of availability database is not healthy. |
41426 | 16 | 0 | The data synchronization state of this availability database is unhealthy. On an asynchronous-commit availability replica, every availability database should be in the SYNCHRONIZING state. On a synchronous-commit replica, every availability database should be in the SYNCHRONIZED state. |
41427 | 16 | 0 | Availability replica is not joined. |
41428 | 16 | 0 | This secondary replica is not joined to the availability group. For an availability replica to be successfully joined to the availability group, the join state must be Joined Standalone Instance (1) or Joined Failover Cluster (2). For information about how-to join a secondary replica to an availability group, see SQL Server Books Online. |
41500 | 10 | 0 | An error (0x%08x) occurred when asynchronous operations administrator attempted to notify the client (ID %ls) of the completion of an operation. This is an information message only. No user action is required. |
41501 | 16 | 0 | Failed to register client (ID %ls) with asynchronous operations administrator. A client with this ID has already been registered. Check that the specified client ID is correct, then retry the operation. To re-register a client, the client must first be deregistered. |
41502 | 16 | 0 | Failed to deregister client (ID %ls) from asynchronous operations administrator. The client has not registered with the administrator. Check that the specified client ID is correct, then retry the operation. |
41503 | 16 | 0 | Client (ID %ls) failed to submit work to asynchronous operations administrator. The client has not registered with the administrator. Check that the specified client ID is correct, then retry the operation. |
41504 | 16 | 0 | Asynchronous operations administrator failed to allocate a work item for the work submitted by client (ID %ls). The administrator may have exhausted all available resources. If this condition persists, contact the system administrator. |
41505 | 16 | 0 | Asynchronous operations administrator failed to queue a work item for the work submitted by client (ID %ls) (internal error %d). The administrator may have exhausted all available resources. If this condition persists, contact the system administrator. |
41600 | 16 | 0 | An error has occurred while executing an asynchronous operation for a database replica (Windows Fabric partition ID %ls, operation %d, error 0x%08x). Refer to the error code for more details. If this condition persists, contact the system administrator. |
41601 | 16 | 0 | Valid state transition is not found for local replica with partition ID %ls (current state %ls, trigger %ls, current epoch [%I64d,%I64d], triggering epoch [%I64d,%I64d]). The replica is not in the correct state to accept the Windows Fabric command. If this condition persists, contact the system administrator. |
41602 | 16 | 0 | An error has occurred while attempting to access replica publisher's subscriber list (partition ID %ls, SQL OS error code 0x%08x). Refer to the error code for more details. If this condition persists, contact the system administrator. |
41603 | 16 | 0 | The transport subscriber failed to process the build secondary replica event (partition ID %ls). If this condition persists, contact the system administrator. |
41604 | 16 | 0 | The transport subscriber failed to process the configuration change replica event (partition ID %ls). If this condition persists, contact the system administrator. |
41605 | 16 | 0 | Cannot associate replica (Windows Fabric replica ID 0x%08X) with the specified Windows Fabric partition (ID %ls). The replica is already associated with a Windows Fabric partition (ID %ls). If this condition persists, contact the system administrator. |
41606 | 16 | 0 | Replica (Windows Fabric replica ID 0x%08X, current state '%ls') cannot process configuration-update command for Windows Fabric partition (ID %ls). Configuration updates can be process by the primary replica only. If this condition persists, contact the system administrator. |
41607 | 16 | 0 | Operation timed out while waiting for %ls access to the cached information in the replica controller (Windows Fabric replica ID 0x%08X, partition ID %ls). If this condition persists, contact the system administrator. |
41608 | 16 | 0 | Failed to obtain %ls access to the cached information in the replica controller (Windows Fabric replica ID 0x%08X, partition ID %ls, SQL OS error %d). The operation may have been aborted. Refer to the SQL OS error number for details. If this condition persists, contact the system administrator. |
41609 | 16 | 0 | Operation timed out while waiting for %ls access to the list of replica controller objects. If this condition persists, contact the system administrator. |
41610 | 16 | 0 | Failed to obtain %ls access to the list of replica controller objects (SQL OS error %d). The operation may have been aborted. Refer to the SQL OS error number for details. If this condition persists, contact the system administrator. |
41611 | 16 | 0 | Replica controller for the local replica (Availability Group ID %ls) cannot be found. Make sure the specified Availability Group ID is correct, then retry the operation. If this condition persists, contact the system administrator. |
41612 | 16 | 0 | An error has occurred while %ls %ls database (SQL Error Code: %d). Refer to the SQL error code for more details. If this condition persists, contact the system administrator. |
41613 | 17 | 0 | Fabric Service '%ls' failed to perform database operation '%ls' on '%ls' database (ID %d). The database might be in an incorrect state for the operation. If this condition persists, contact the system administrator. |
41614 | 10 | 0 | Fabric Service '%ls' encountered a transient error while performing Windows Fabric operation on '%ls' database (ID %d). Refer to the SQL Server error log for information about the errors that were encountered. If this condition persists, contact the system administrator. |
41615 | 10 | 0 | Fabric Service '%ls' encountered a permanent error while performing a Windows Fabric operation on '%ls' database (ID %d). Refer to the SQL Server error log for information about the errors that were encountered. If this condition persists, contact the system administrator. |
41616 | 16 | 0 | SQL Server cannot find the configuration of the replica with ID %ls (Windows Fabric partition ID %ls). Make sure the specified Windows Fabric partition ID and replica ID are correct, then retry the operation. If this condition persists, contact the system administrator. |
41617 | 10 | 0 | Fabric Service '%ls' is unable to find out start of log and end of log LSN for '%ls' database. Refer to the SQL Server error log for information about the errors that were encountered. If this condition persists, contact the system administrator. |
41618 | 16 | 0 | Attempt to access non-existent or uninitialized Windows Fabric partition '%ls'. This is usually an internal condition, such as the Windows Fabric service is getting initialized or it is getting destroyed. |
41619 | 16 | 0 | Windows Fabric '%ls' (partition ID '%ls')encountered transient error %d while waiting for build replica operation on database '%ls' (ID %d). Refer to the SQL Server error log for information about the errors that were encountered. If this condition persists, contact the system administrator. |
41620 | 10 | 0 | Build replica operation on database '%ls' (ID %d) of Windows Fabric partition '%ls' (partition ID '%ls') has been cancelled by Windows Fabric. Windows Fabric cancelled build replica operation. This is an informational message only. No user action is required. |
41621 | 10 | 0 | Windows Fabric partition '%ls' (partition ID '%ls') encountered error '%ls' and is reporting '%ls' failure to Windows Fabric. Refer to the SQL Server error log for information about the errors that were encountered.. If this condition persists, contact the system administrator. |
41622 | 16 | 0 | Windows Fabric service '%ls' (partition ID '%ls') is trying to update primary replica information for local replica %ls which is neither ACTIVE_SECONDARY nor IDLE_SECONDARY (current role %ls). SQL Server cannot update primary replica information in invalid state. This is an informational message only. No user action is required. |
41623 | 20 | 0 | The Database Mirroring endpoint port is unavailable. Verify that the DBM endpoint is created. |
41624 | 16 | 0 | Drop database '%ls' (ID %d) of Windows Fabric partition '%ls' (partition ID '%ls') has failed. SQL Server has failed to drop the database. If this condition persists, contact the system administrator. |
41625 | 20 | 0 | The internal buffer for the replication URL is insufficient. |
41626 | 10 | 0 | Failed to retrieve service desription from Windows Fabric for partition '%ls' (Windows Fabric error 0x%08x). If this condition persists, contact the system administrator. |
41627 | 10 | 0 | An error has occurred while Dropping %ls database (SQL Error Code: %d). Refer to the SQL error code for more details. If this condition persists, contact the system administrator. |
41628 | 10 | 0 | Drop database Timer task encountered an error (SQL Error Code: %d). Refer to the SQL error code for more details. If this condition persists, contact the system administrator. |
41629 | 10 | 0 | Fabric replica publisher encountered an error (SQL Error Code: %d, State: %d) while publishing event '%ls' to subscriber of type '%ls' on Fabric partition '%ls' (partition ID: '%ls'). Refer to the SQL error code for more details. If this condition persists, contact the system administrator. |
41630 | 10 | 0 | Failed to update primary replica information for partition '%ls' (Windows Fabric error 0x%08x). This is an informational message only. No user action is required. |
41631 | 16 | 0 | Fabric service '%ls' failed to retrieve a known hardware sku while performing a build replica operation on '%ls' database (ID %d). Refer to the cluster manifest to ensure a valid SKU is defined for this node type. If this condition persists, contact the system administrator. |
41632 | 10 | 0 | The system encountered SQL Error %d (severity: %d, state: %d), which has no corresponding error text. Refer to the SQL Error number for more information regarding the cause and corrective action. |
41633 | 16 | 0 | Fabric Service '%ls' (partition ID '%ls') is unable to allocate a work item for the database restart of '%ls' database (ID %d). The administrator may have exhausted all available resources. If this condition persists, contact the system administrator. |
41634 | 10 | 0 | Open replica operation on database '%ls' (ID %d) of Windows Fabric partition ID '%ls' has been cancelled. This is an informational message only. No user action is required. |
41635 | 10 | 0 | Open replica operation on database '%ls' (ID %d) of Windows Fabric partition ID '%ls' failed. For more information, see the SQL Server error log. This is an informational message only. No user action is required. |
41636 | 16 | 0 | Fabric Service '%ls' (partition ID '%ls') is unable to enqueue a work item for the database restart of '%ls' database (ID %d). The administrator may have exhausted all available resources. If this condition persists, contact the system administrator. |
41637 | 16 | 0 | The database '%ls' (URI: '%ls', partition ID '%ls') is not currently participating in a GeoDR relationship. |
41638 | 16 | 0 | Could not retrieve remote replica storage configuration for database '%ls' (URI: '%ls'). |
41639 | 16 | 0 | Could not retrieve remote replica configuration for database '%ls' (URI: '%ls'). |
41640 | 10 | 0 | Database '%ls' encountered a transient error (error code: 0x%08X) while performing task '%ls'. Refer to the SQL Server error log for information about the errors that were encountered. If this condition persists, contact the system administrator. |
41641 | 16 | 0 | Could not send global cluster action '%ls' request 0x%x. |
41642 | 10 | 0 | Undo of redo is run in Active Secondary role on database '%ls' (ID %d). Recovery lsn: '%S_LSN', Hardened lsn: '%S_LSN'. If this condition persists, contact the system administrator. |
41643 | 16 | 0 | Could not retrieve the Layered AG Configuration for database '%ls' (URI: '%ls', partition ID '%ls') . Encountered error (error code: 0x%08X). |
41644 | 17 | 0 | Fabric Service '%ls' failed to perform database operation '%ls' on database '%ls'. The database might be in an incorrect state for the operation. If this condition persists, contact the system administrator. |
41645 | 16 | 0 | Fabric Service '%ls' (partition ID '%ls') encountered error (error code: 0x%08X) while querying for Fabric property '%ls'. |
41646 | 16 | 0 | Invalid Fabric property '%ls' received for partition '%ls'. |
41647 | 17 | 0 | Failed to start the report fault thread during replica manager startup. |
41648 | 10 | 0 | Get current progress was called on '%ls' database (ID %d) which had undo of redo pending. Refer to the SQL Server error log for information about the errors that were encountered. If this condition persists, contact the system administrator. |
41649 | 10 | 0 | Could not submit Change Role completion tasks for %ls' (URI: '%ls', partition ID '%ls') . Encountered error (error code: 0x%08X). |
41650 | 10 | 0 | Waiting for replica catchup for AGID '%ls' and ReplicaID '%ls' Failed. |
41651 | 16 | 0 | Invalid partition id in replica manager |
41652 | 17 | 0 | The replica manager is unavailable or not ready. |
41653 | 21 | 0 | Database '%.*ls' encountered an error (error type: %d '%.*ls') causing failure of the availability group '%.*ls'. Refer to the SQL Server error log for information about the errors that were encountered. If this condition persists, contact the system administrator. |
41654 | 17 | 0 | Failed to start the clean up nonexistant DBs thread during replica manager startup. |
41655 | 10 | 0 | Could not submit logical reseeding task for '%ls' (URI: '%ls', partition id: '%ls') . Encountered error (error code: 0x%08X). |
41656 | 17 | 0 | Failed to start the windows fabric load balancer reporting thread during replica manager startup. |
41657 | 16 | 0 | Database '%ls' (ID %d) of Windows Fabric partition '%ls' (partition ID '%ls') failed the call to UseDB. |
41658 | 16 | 0 | Failed to automatically enable Query Store in Database '%ls' (ID %d) of Windows Fabric partition '%ls' (partition ID '%ls') . |
41659 | 16 | 0 | Checkpoint for Database '%ls' (ID %d) failed. Encountered error (error code: 0x%08X). |
41660 | 16 | 0 | Windows Fabric service '%ls' (partition ID '%ls') received a primary replica information message from remote replica '%ls' with an epoch [%I64d,%I64d] which is less than the local epoch [%I64d,%I64d]. SQL Server cannot update primary replica information from a replica with a smaller epoch. This is an informational message only. No user action is required. |
41661 | 16 | 0 | There are no waiters on the DataLossEvent for Fabric Service '%ls' (partition ID '%ls'). |
41662 | 16 | 0 | Database '%ls' (ID %d) of Windows Fabric partition '%ls' (partition ID '%ls') hit exception while running async tasks in Generic Subscriber. |
41663 | 10 | 0 | Failed to parse datawarehouse columnar cache settings during replica manager startup. |
41700 | 16 | 0 | System views related to Windows Fabric partitions and replicas are not available at this time, because replica manager has not yet started. Wait for replica manager to start, then retry the system view query. |
41701 | 20 | 0 | The Activation Context is unavailable at this time. The Windows Fabric Runtime is unavailable at this time, retry later. Wait for the activation context to become available, then retry. |
41702 | 20 | 0 | The requested Configuration Package is unavailable at this time. The Configuration Package is not a part of the Activation Context. Verify that the requested Configuration Package name exists and is properly formatted. |
41703 | 20 | 0 | The requested Service Endpoint is unavailable at this time. The Service Endpoint is not a part of the Activation Context. Verify that the requested Service Endpoint name exists and is properly formatted. |
41704 | 20 | 0 | The datasource name is not correctly formatted. The datasource name exceeds the maximum path length or does not adhere to defined format. Verify that the datasource is name is fewer than MAX_PATH characters in length is properly formatted. |
41705 | 20 | 0 | The computer name is unavailable. The computer name was not returned. |
41706 | 20 | 0 | Unable to get Fabric NodeContext. |
41801 | 16 | 0 | Failed to drop the memory optimized container '%.*ls'. |
41802 | 16 | 0 | Cannot drop the last memory-optimized container '%.*ls'. |
41803 | 16 | 0 | An In-Memory OLTP physical database was restarted while processing log record ID %S_LSN for database '%.*ls'. No further action is necessary. |
41804 | 16 | 0 | Internal error for database '%.*ls' (lookup for HkTruncationLsn failed). The operation will be retried. No user action is required. If the problem persists, contact customer support. |
41805 | 16 | 0 | There is insufficient memory in the resource pool '%ls' to run this operation on memory-optimized tables. See 'http://go.microsoft.com/fwlink/?LinkID=614951' for more information. |
41806 | 16 | 0 | Parameter "%ls" specified for procedure or function "%ls" is not valid. |
41807 | 16 | 0 | A MARS batch failed due to a unique constraint violation on a memory optimized table. |
41808 | 16 | 0 | The current MARS batch attempted to update a record that has been updated by another batch within the same transaction. |
41809 | 16 | 0 | Natively compiled triggers do not support statements that output a result set. |
41810 | 16 | 0 | Stored procedures called from natively compiled triggers do not support statements that output a result set. |
41811 | 16 | 0 | XTP physical database was stopped while processing log record ID %S_LSN for database '%.*ls'. No further action is necessary. |
41812 | 16 | 0 | ALTER TABLE on memory-optimized tables is not supported with concurrent MARS transactions. |
41813 | 16 | 0 | XTP database '%.*ls' was undeployed. No further action is necessary. |
41814 | 16 | 0 | The procedure '%.*ls' cannot be called from a user transaction. |
41815 | 16 | 0 | Data migration on table id %d cannot be performed because the table is already in the process of migration. |
41816 | 16 | 0 | The parameter '%.*ls' for procedure '%.*ls' cannot be NULL. |
41817 | 16 | 0 | Invalid object id %d provided as input for procedure '%.*ls'. The object id must refer to a memory-optimized table with a column store index. |
41818 | 23 | 0 | An upgrade operation failed for database '%.*ls' attempting to upgrade the XTP component from version %u.%u to version %u.%u. Check the error log for further details. |
41819 | 16 | 0 | A MARS batch failed due to a validation failure for a foreign key constraint on memory optimized table '%.*ls'. Another interleaved MARS batch deleted or updated a row that was referenced by a foreign key row inserted by the failed batch. |
41820 | 16 | 0 | A MARS batch failed due to a validation failure for a foreign key constraint on memory optimized table '%.*ls'. Another interleaved MARS batch inserted a row that references the row that was deleted by the failed batch. |
41822 | 17 | 0 | There is insufficient disk space to generate checkpoint files and as a result the database is in delete-only mode. In this mode, only deletes and drops are allowed. |
41823 | 16 | 0 | Could not perform the operation because the database has reached its quota for in-memory tables. See 'http://go.microsoft.com/fwlink/?LinkID=623028' for more information. |
41824 | 16 | 0 | The transaction was killed by a concurrent ALTER operation or by a write-write conflict. |
41825 | 16 | 0 | Stored procedure '%.*ls' cannot be used to increase the user memory limit on the database. |
41826 | 16 | 0 | Stored procedure '%.*ls' tried to set a lower limit to the user memory quota. The operation failed because the user memory consumption is larger than the specified target, delete some user data and try the operation again. |
41827 | 16 | 0 | Upgrade of XTP physical database '%.*ls' requires restart of XTP engine. |
41828 | 16 | 0 | Creation of memory-optimized tables is temporarily disabled. Please try again later. |
41829 | 16 | 0 | The database cannot proceed with pricing-tier update as it has memory-optimized objects. Please drop such objects and try again. |
41830 | 16 | 0 | Upgrade of XTP physical database '%.*ls' restarted XTP engine. |
41831 | 16 | 0 | Data migration on table id %d failed either fully or partially. See errorlog for details. |
41832 | 16 | 0 | Index '%.*ls' cannot be created on table '%.*ls', because at least one key column is stored off-row. Index key columns memory-optimized tables must fit within the %d byte limit for in-row data. Simplify the index key or reduce the size of the columns to fit within %d bytes. |
41833 | 16 | 0 | Columnstore index '%.*ls' cannot be created, because table '%.*ls' has columns stored off-row. Columnstore indexes can only be created on memory-optimized table if the columns fit within the %d byte limit for in-row data. Reduce the size of the columns to fit within %d bytes. |
41834 | 16 | 0 | ALTER TABLE has failed for '%.*ls' with error code %d. |
41835 | 21 | 0 | An error (error code: 0x%08lx) occurred while adding encryption keys to XTP database '%.*ls'. |
41836 | 16 | 0 | Rebuilding log is not supported for databases containing files belonging to MEMORY_OPTIMIZED_DATA filegroup. |
41837 | 16 | 0 | Boot-page adjustment of XTP database '%.*ls' requires restart of XTP engine. |
41838 | 16 | 0 | Failed to retrieve size for this file due to an internal error. Please try again later. |
41839 | 16 | 0 | Transaction exceeded the maximum number of commit dependencies and the last statement was aborted. Retry the statement. |
41840 | 16 | 0 | Could not perform the operation because the elastic pool has reached its quota for in-memory tables. See 'http://go.microsoft.com/fwlink/?LinkID=623028' for more information. |
41841 | 23 | 0 | Found inconsistent boot-page for database '%.*ls'. |
41842 | 16 | 0 | Too many rows inserted or updated in this transaction. You can insert or update at most 4,294,967,294 rows in memory-optimized tables in a single transaction. |
41843 | 16 | 0 | Unable to construct segment for segment table. |
41844 | 15 | 0 | Clustered columnstore indexes are not supported on memory optimized tables with computed columns. |
41845 | 16 | 0 | Checksum verification failed for memory optimized checkpoint file %.*ls. |
41846 | 16 | 0 | Memory optimized checkpoint table consistency error detected. Checkpoint %I64d does not have unique recoverLsn. PrevLSN = (%I64d:%hu), CurrLSN = (%I64d:%hu). |
41847 | 16 | 0 | Memory optimized checkpoint table consistency error detected. Checkpoint %I64d does not point to a transaction segment definition record. |
41848 | 16 | 0 | Memory optimized checkpoint table consistency error detected. Checkpoint %I64d does not have ascending recoverLsn. PrevLSN = (%I64d:%hu), CurrLSN = (%I64d:%hu). |
41849 | 16 | 0 | Memory optimized segment table consistency error detected. Segments are not contiguous in logical space. Older Segment CkptId = %I64d, LsnInfo = (%I64d:%hu), TxBegin = %I64d, TxEnd = %I64d. Newer Segment CkptId = %I64d, LsnInfo = (%I64d:%hu), TxBegin = %I64d, TxEnd = %I64d. |
41850 | 16 | 0 | Memory optimized segment table consistency error detected. Segments are not well formed for Segment CkptId = %I64d, LsnInfo = (%I64d:%hu), TxBegin = %I64d, TxEnd = %I64d. |
41851 | 16 | 0 | Memory optimized segment table consistency error detected. Segment definition ordering does not match the (strict) logical ordering. Older Segment CkptId = %I64d, LsnInfo = (%I64d:%hu), TxBegin = %I64d, TxEnd = %I64d. Newer Segment CkptId = %I64d, LsnInfo = (%I64d:%hu), TxBegin = %I64d, TxEnd = %I64d. |
41852 | 16 | 0 | Memory optimized segment table consistency error detected. Segment has a NullHkLsn. CkptId = %I64d, Segment LsnInfo = (%I64d:%hu) |
41853 | 16 | 0 | Memory optimized segment table consistency error detected. Current segment goes backward further than the definition record of the N-2 segment. Older Segment CkptId = %I64d, LsnInfo = (%I64d:%hu), TxBegin = %I64d, TxEnd = %I64d. Newer Segment CkptId = %I64d, LsnInfo = (%I64d:%hu), TxBegin = %I64d, TxEnd = %I64d. |
41854 | 16 | 0 | Memory optimized file consistency error detected. An in use file with FileId %.*ls is referenced by the Checkpoint File Table but is not accounted for in the Storage Interface. |
41855 | 16 | 0 | Memory optimized file consistency error detected. Could not find a file with FileId %.*ls in the File Watermark Table visible by checkpoint ID %u. |
41856 | 16 | 0 | Memory optimized file consistency error detected. A file with FileId %.*ls of size %I64d bytes is smaller than expected %I64d bytes. |
41857 | 16 | 0 | Memory optimized file consistency error detected. A presumably in use file with FileId %.*ls was not found in the Checkpoint File Table. |
41858 | 16 | 0 | Memory optimized file consistency error detected. A presumably in use file with FileId %.*ls was not found in the File Watermark Table. |
41859 | 16 | 0 | Memory optimized file consistency error detected. A presumably in use file with FileId %.*ls of size %I64d bytes is smaller than expected (%I64d bytes) |
41860 | 16 | 0 | Memory optimized file consistency error detected. A presumably unused file with FileId %.*ls was found in the Checkpoint File Table. |
41861 | 16 | 0 | Memory optimized large rows table consistency error detected. File Id is %.*ls. Corresponding LSN range is not ascending. Begin Lsn is (%I64d:%hu), End Lsn is (%I64d:%hu). |
41862 | 16 | 0 | Memory optimized large rows table consistency error detected. Corresponding File %.*ls not found in File Table. Begin Lsn is (%I64d:%hu), End Lsn is (%I64d:%hu). |
41863 | 16 | 0 | Checkpoint %I64d points to a root file %.*ls which was in use by a more recent checkpoint. |
41864 | 16 | 0 | Checkpoint %I64d has a file %.*ls which has a watermark (%I64d) larger than the more recent checkpoints watermark (%I64d). |
41865 | 16 | 0 | File %.*ls does not have a pair file %.*ls |
41866 | 16 | 0 | Unprocessed File %.*ls does not have a pair file which is also unprocessed. Processed pair file is %.*ls. |
41867 | 16 | 0 | Consistency errors detected in the MEMORY_OPTIMIZED_DATA filegroup. See preceding error messages for details. Consult https://go.microsoft.com/fwlink/?linkid=845604 for details on how to recover from the errors. |
41868 | 16 | 0 | Memory optimized filegroup checks could not be completed because of system errors. See errorlog for more details. |
41901 | 16 | 0 | One or more of the options (%ls) are not supported for this statement in SQL Managed Instance. Review the documentation for supported options. |
41902 | 16 | 0 | Unsupported device type. SQL Managed Instance supports database restore from URI backup device only. |
41903 | 16 | 0 | CREATE DATABASE failed. Cannot create filename %ls. Local file paths are not supported. |