Database Engine Errors
SQL Server diagnostic error codes organized by severity level and category. Each error includes error number, severity classification, and description. — Page 11 of 11.
Description 45716 16 No Configuring the 'VBS' preferredEnclaveType for databases using the DC- series hardware configuration is not supported.
Description 45728 16 No Adding a database with '{0}' preferredEnclaveType to an elastic pool '{1}' with '{2}' preferredEnclaveType is not supported.
Description 45769 16 No %ls 45770 16 No Failed to move the database into elastic pool due to internal resource constraints. This may be a transient condition, please retry. 45771 16 No Import/Export w
Description 45789 16 No The limit of one free database offer for subscription '%.*ls' has been reached. Drop the existing free database or use a different subscription to continue. 45790 16 No Operati
Description 45903 16 No Changing the database format from '{0}' to '{1}' is not supported. Check the database format property value specified. For more information, see https://go.microsoft.com/fwlink
Description 45915 16 No Failover operation cannot be performed because of database format mismatch between the instances in the failover group.
Description 45941 16 No The operation could not be completed as the backup is not configured for immutability. 45942 16 No The operation could not be completed as the backup is immutable and locked. 4
Description 46519 15 No %ls are not supported with %S_MSG. 46520 15 No The external DDL statement contained an unrecognized option.
Description 46540 15 No '%S_MSG' statement failed. Partitioning columns can be specified only if distribution type is '%S_MSG'. 46541 15 No '%S_MSG' statement failed. The column name '%.*ls' specified
Description 46557 16 No Argument '%.*ls' is invalid. Please provide a valid Json document. 46558 16 No Option '%S_MSG' is not supported for external tables. 46559 16 No Local temporary external tables
Description 46622 16 No DISTRIBUTION 46623 16 No DATABASE_NAME 46624 16 No SHARD_MAP_NAME 46625 16 No CREDENTIAL 46626 16 No REMOTE_SCHEMA_NAME 46627 16 No REMOTE_OBJECT_NAME 46628 16 No SHARED_MEMORY
Description 46661 16 No CREATE EXTERNAL TABLE 46662 16 No HASH 46663 16 No PARTITION 46664 16 No DROP EXTERNAL TABLE 46665 16 No TRUNCATE EXTERNAL TABLE 46666 16 No ALTER DATABASE 46667 16 No DROP DAT
Description 46707 16 No The given IPC request with code %d is not supported for SQL Server Parallel DataWarehousing TDS endpoint.
Description 46803 16 No Failed to locate entry point for global query module. 46804 16 No Failed to initialize the global query module. 46805 16 No Conversion error while constructing the GlobalQuery
Description 46826 16 No Output parameters are not supported with %.*ls. 46827 16 No The option '%ls' must be turned ON to execute queries referencing external tables.
Description Please restart Polybase engine and DMS services. 46903 10 No This stored procedure is not available because Polybase feature is not enabled. 46904 16 No Failed to get the computer name. Th
Description 46921 16 No The EXECUTE AT DATA_SOURCE command is not supported for this external data source type. 46922 21 No PolyBase provisioning script performing on master database failed. This is a
Description 46943 16 No Unable to fetch S3 temporary credentials from STS due to insufficient memory. 46944 16 No Unable to fetch S3 temporary credentials from STS due to internal error. 46945 16 No I
Description 46962 16 No Try to reuse default external file format name '%.*ls' but its FORMAT_TYPE attribute '%.*ls' is not consistent with the default file format name.
Description 47016 10 No Reason: FedAuth AzureActiveDirectoryService Initialization failed when opening Certificate Store. 47017 10 No Reason: FedAuth AzureActiveDirectoryService Initialization failed
Description error code 47033 10 No Reason: There is a System error in FedAuth token parsing. There should be a separate XEvent called 'fedauth_webtoken_failure' which indicate the actual error code 47
Description 47052 10 No Reason: Unexpected error while extracting VNET metadata info from the IPv6 (VNET parsing). 47053 10 No Reason: Unexpected error on VNET firewall rule table lookup. 47054 10 No
Description contact your system administrator. 47071 10 No Reason: Login failed because login token present in the feature extension is invalid.
Description 47091 10 No Reason: Login failed because login does not have CONNECT permission on the specified SQL Pool. 47092 10 No Reason: Login failed because login to Datawarehouse Reserved Database
Description 47107 16 No The %ls operation is not allowed by the current availability group configuration. The availability group '%.*ls' only supports one replica which has configuration-only availabi
Description expiration time cannot be set to an earlier time than its current value. 47120 16 No The READ_WRITE_ROUTING_URL '%.*ls' specified for availability replica '%.*ls' is not valid.
Description 47133 16 No Joining availability group '%.*ls' with rebuilding contained system databases has failed because rebuilding contained availability group master database has failed.
Description current state, or the specified cluster resource name or ID is invalid. Otherwise, contact your primary support provider.
Description 47304 16 No %ld is not a valid value for data retention period. 47305 16 No '%.*ls' is not a valid period unit for data retention.
Description 47503 16 No AG '%.*ls' already contains one database and adding more is not supported because AG participates in distributed availability group '%.*ls' with secondary on Azure SQL Managed
Description 47516 16 No Failover cannot be completed as the redo log is too large. Most likely secondary might be too busy, or the workload from the primary is too demanding.
Description 47700 10 No Reason: The External Provider Access Token used for authenticating to the SQL Server is Blocklisted.
Description 49404 16 No Value '%.*ls' for option '%.*ls' is not supported in this version of SQL Server. 49405 17 Yes Skipping the default startup of vldb database '%.*ls'. The database will be starte
Description 49424 16 Yes Transformation of the log file to Hyperscale format failed. 49425 16 Yes Oldest begin LSN is smaller than foreign redo LSN which will prevent Page Server creation. Operation w
Description 49514 10 No %lsDBCC %ls for database id %d found %d errors and repaired %d errors. Elapsed time: %d hours %d minutes %d seconds.
Description 49530 10 No The requested repair finished successfully. 49531 16 No The operation failed because the internal repair command is invalid. 49532 16 No DBCC SHRINKFILE for data files is not s
Description 49703 10 No Failed to parse server override on server '%.*ls'. The category name is: '%.*ls' and the override string is: '%.*ls'. 49704 10 No Failed to apply server override on category '%
Description 49811 10 No Deactivation is not supported on Disabled database: Server '%.*ls', Database '%.*ls' 49812 10 No EnableForceNoBackupDeactivation is not enabled: Server '%.*ls', Database '%.*ls
Description 49903 10 Yes Detected %I64d MB of RAM, %I64d MB of available memory, %I64d MB of available page file. This is an informational message; no user action is required. 49904 10 Yes The service
Description create/update requests are complete or delete one of your pending create/update requests and retry your request later. 49920 16 No Cannot process request. Too many operations in progress f
Description 49937 10 No ERROR: A failure occurred in the licensing subsystem. Error [%d]. 49938 10 No The licensing PID was successfully processed. The new edition is [%s].
Description 49954 10 No setting the ACCEPT_EULA environment variable, or using the mssql-conf tool. 49955 10 No Environment Variable Startup Parameters:%.*ls 49956 10 No The default language (LCID %d)
Description 49974 16 No CREATE DATABASE statement is not supported in a Synapse workspace. To create a SQL pool, use the Azure Synapse Portal or the Synapse REST API. 49975 10 No Unable to load contro
Description 49991 16 No The requested service level objective for this pool exceeds the current limit. To increase the limit, please create support ticket.
This error typically indicates damaged backup(s) or the media that stores or transferred the backups malfunctioned.
Description transient. Please retry the operation. See ' http://go.microsoft.com/fwlink/? LinkID=623028 ' for more information. 41841 23 No Found inconsistent boot-page for database '%.*ls'. 41842 16
An empty string means that SQL Server tried to hand off the credentials to the Local Security Authority Subsystem Service (LSASS) but couldn't because of some problem. Either LSASS wasn't available, o
Strict configuration settings are required to reduce latency to mirrors or to raid rebuild operations. Microsoft doesn't support SQL Server data files and log files on compressed drives. NTFS compress
4. Then right-click on each column and choose to apply the following filters: the event to be the only one displayed field='query processing' <> 'clean'. 5.
Description that this operation can impact performance while it is running and may take several hours to complete. Refer to the following article for details of using T-SQL to run DBCC SHRINKDATABASE:
Description linkid=871071 ). You can find more details about this error in the virtual network Activity log. 45398 16 No The specified edition %ls is not consistent with the specified SKU %ls. 45399 1
Indicates informational messages that return status information or report errors that aren't severe. For compatibility reasons, the Database Engine converts severity 10 to severity 0 before returning the error information to the calling application.
A special severity for queries that don't use locking because of special query hints. In some cases, read operations performed by these statements could result in inconsistent data because locks aren't taken to guarantee consistency.
Indicates general errors that can be corrected by the user. 17-19 Indicate software errors that can't be corrected by the user. Inform your system administrator of the problem.
Indicates a problem in the Database Engine software, but the statement completes, and the connection to the instance of the Database Engine is maintained. The system administrator
Indicates that the statement caused SQL Server to run out of resources (such as memory, locks, or disk space for the database) or to exceed some limit set by the system administrator.
Indicates that a nonconfigurable Database Engine limit has been exceeded and the current the system administrator or your primary support provider. Contact your system level from 19 through 25 are written to the error log.
Indicates that a problem has been encountered that affects all tasks in the current database, but it's not likely that the database itself is damaged.
Indicates that a statement encountered a problem. Because the problem affected only the current task, it's not likely that the database itself is damaged.
Indicates that the table or index specified in the message has been damaged by a software or hardware problem. to determine whether other objects in the database are also damaged.
Indicates that the integrity of the entire database is in question because of a hardware or software problem. to determine the extent of the damage. The problem might be in the cache only and not on the disk itself.
Indicates a media failure. The system administrator might need to restore the database. You might also need to call your hardware vendor. You can use to add user-defined error messages with severities from 1 through to the catalog view. These user-de