Database Engine Errors

Description 33105 16 No Cannot drop the database encryption key because it is currently in use. Database encryption needs to be turned off to be able to drop the database encryption key. 33106 16 No C

Description 33122 16 No This command requires a database encryption scan on database '%.*ls'. However, the database has changes from previous encryption scans that are pending log backup. Take a log b

Description 33140 16 No The login '%.*ls' could not be created because a login is already associated with certificate '%.*ls'.

Description 33157 16 No Cryptographic providers are not supported on database credentials. 33158 16 No Database credentials are not supported in master database.

Description 33174 16 No Cannot get credential '%.*ls' because it is not referenced by any external data source. 33175 16 No Encryption operation failed. Key used for encryption has deprecated algorith

Description Support Services. 33191 16 Yes Enclave host encountered a runtime error: out of priority queue space. 33192 16 Yes Internal enclave error. Enclave raised an exception (major = %d, minor =

Description 33209 10 No Audit '%.*ls' has been changed to ON_FAILURE=CONTINUE because the server was started by using the -m flag. because the server was started with the -m flag. 33210 10 No SQL Serv

Description 33224 16 No The specified pattern did not return any files or does not represent a valid file share. Verify the pattern parameter and rerun the command.

Description timeout. 33242 16 No When providing a sid, the user must be a user without login or a user with password.

'Description 33257 16 No Cannot drop an audit store URL that is not configured for this database audit. 33258 16 No Invalid value for procedure "%.*ls", parameter "%.*ls". 33259 15 No Invalid security '

Description 33275 16 No The encrypted value for this column encryption key cannot be dropped. Each column encryption key must have at least one encrypted value. 33277 16 No Encryption scheme mismatch

Description 33291 16 No There is already a column encryption key value associated with the column master key '%.*ls'. 33292 16 No The encryption algorithm '%.*ls' is not supported.

Description 33308 10 No The queue %d in database %d has activation enabled and contains unlocked messages but no RECEIVE has been executed for %u seconds.

Description 33331 16 No DBCC CLEANUPCONVERSATIONS is not allowed on this server. 33332 16 No DBCC CLEANUPCONVERSATIONS cannot be executed through MARS connection.

Description 33408 16 No The operation caused a FileTable check constraint error. A directory entry cannot have a data stream associated with the row.

Description 33420 16 No Unable to process object '%.*s' because it is a three-part or four-part name. Specifying the server or database is not supported in the object identifier.

Description '%.*ls', unless FILETABLE_NAMESPACE is disabled. 33440 16 No When inserting into FileTable '%.*ls' using BCP or BULK INSERT, either CHECK_CONSTRAINTS option needs to be on, or FILETABLE_NA

Description might limit the usability of FILESTREAM File I/0 access after an availability group failover. Therefore, we recommend that you create a listener for each availability group. For informatio

Description 33510 16 No BLOCK security predicates cannot reference history tables. Table '%.*ls' is a temporal or ledger history table. 33511 16 No Table '%.*ls' is memory optimized.

Description 33524 10 No The fn_get_audit_file function is skipping records from '%.*ls'. You must be connected to database '%.*ls' to access its audit logs. 33525 10 No The fn_get_audit_file function

Description 33540 16 No Invalid audit or database names, please use valid URL characters. 33541 16 No The credentials of blob storage container '%.*ls' was not found. 33542 16 No Unsupported operation

Description 33554 16 Yes Encountered x%08lx while waiting for encryption scan completion consensus. See the errorlog for details. 33555 16 Yes Unable to find the user-specified certificate [Cert Hash(

Description 33570 10 No Specified workload group does not exist. Switching to default workload group for TDE encryption scan. 33571 16 No Cannot create server audit with GUID '%s' in this version of S

Description 33585 16 No Windows principal '%ls' does not map to provided Microsoft Entra ID principal '%ls', please use a different Microsoft Entra ID principal. 33586 10 No Warning: Index or statisti

Description 33802 16 No Trident DW BCP failed due to an internal error. 34001 16 No Dialog with queue 'syspolicy_event_queue' has encountered an error: %s. 34002 16 No Dialog with queue 'syspolicy_eve

Description 34102 16 Yes An object in serialized stream has version %u but maximum supported version of this class is %u. 34103 16 Yes Error in formatter during serialize/deserialize.

Description 35200 16 No Failed to add database '%.*ls' to availability group '%.*ls'. The specified availability group is created with basic functionality and supports %d database.

Description 35211 16 No The %ls operation is not allowed. The operation attempted to change the configuration of availability replica '%.*ls' to the asynchronous-commit availability mode with automati

Description 35221 16 No Could not process the operation. Always On Availability Groups replica manager is disabled on this instance of SQL Server. Enable Always On Availability Groups, by using the SQ

Description 35231 16 No The specified server instance name, '%ls', is invalid. Reenter the command specifying a valid instance name. 35232 16 No The specified endpoint URL '%.*ls' is invalid. Reenter

Description 35243 16 No Failed to set resource property '%.*ls' for availability group '%.*ls'. The operation encountered SQL Server error %d.

Description 35255 16 No An attempt to start database '%.*ls' failed because the database is already started and online. 35256 16 No The session timeout value was exceeded while waiting for a response

Description 35266 10 No Always On Availability Groups connection with %S_MSG database established for %S_MSG database '%.*ls' on the availability replica '%.*ls' with Replica ID: {%.8x-%.4x-%.4x-%.2x%

As you can see the error can appear on the Primary replica indicating that it lost communication with the Secondary replica, or vice versa.

Description complete and come online. Ensure that the server instance that hosts the primary replica is running.

Description 35285 10 No The recovery LSN %S_LSN was identified for the database with ID %d. This is an informational message only. No user action is required. 35286 16 No Using the recovery LSN %S_LSN

'Description 35295 16 No Log backup for database "%.*ls" on a secondary replica failed because the last backup LSN (0x%ls) from the primary database is greater than the current local redo LSN (0x%ls). '

Description 35307 15 No The statement failed because column '%.*ls' on table '%.*ls' is a computed column. Columnstore index cannot include a computed column implicitly or explicitly. 35308 15 No The

Description 35318 15 No The statement failed because the %S_MSG option is not allowed when creating a columnstore index. Create the columnstore index without specifying the %S_MSG option. 35319 15 No

Description 35329 15 No The statement failed because specifying ORDER is not allowed when creating the rowstore index '%.*ls' on table '%.*ls'. Consider creating the rowstore index without specifying

Description 35344 16 No MERGE clause of ALTER PARTITION statement failed because two nonempty partitions containing a columnstore index cannot be merged.

Description 35353 16 No %s cannot be enabled on a table with a clustered columnstore index. Consider dropping clustered columnstore index '%s' on table '%s'. 35354 16 No The statement failed because a

Description 35368 17 No Internal DDL Operation Error: The DDL encountered an unexpected error %d during execution (HRESULT = 0x%x).

Description 35384 16 No The statement failed because column '%.*ls' on table '%.*ls' is a lob column. Non clustered index with lob column as included column cannot co-exist with clustered columnstore

Description run the query with more memory (change your Resource Governor settings or upgrade to a higher SLO) or target fewer partitions in the load if your target table is partitioned. 35396 17 No E

Description 35419 16 No feature 35420 16 No operation 35421 16 No statement 35422 16 No index option 35423 16 No table option 35424 16 No operator 35425 16 No value 35426 16 No system column 35427 16

Description 35448 10 No partition 35449 16 No signing algorithm 35450 16 No table 35451 16 No join hint 35452 10 No Database unavailable 35453 10 No it is a system database.

Description 35468 16 No Partition DB marked as suspect 35469 16 No Failed to get Partition DB attributes 35470 16 No Partition Host 35471 10 No Partition metadata not found 35472 15 No memory optimize

Description 35520 10 No OPTIMIZE_FOR_SEQUENTIAL_KEY 35521 10 No stale_capture_policy_threshold 35522 10 No day 35523 10 No TRIPLE_DES_3KEY 35524 10 No AES_256 35525 10 No STATISTICS_ONLY 35526 10 No s

Description 35544 10 No Empty internal distributed availability group. 35545 10 No Internal distributed availability group naming inconsistency.

Description 37006 16 No Cannot perform the operation because the specified instance of SQL Server is not enrolled in a SQL Server utility. 37007 16 No An error occurred during upload to the SQL Server

Description 37302 16 Yes %ls. Internal error. API: '%ls'. Return code: '0x%08x'. For more information, contact Customer Support Services. 37303 16 Yes Internal error occurred while obtaining an authen

Description 37318 16 Yes Unable to acquire an authentication token for resource_id '%ls' with URL '%ls'. Return code: '0x%08x' Correlation Id: '%ls'. For more information, contact Customer Support Ser

Description 37331 16 No DevOps login, '%s', can not be created as another non-devops server principal with name or object ID already exists.

Description 37347 16 No 'GENERATED ALWAYS AS %ls' column '%.*ls' cannot be nullable. 37348 16 No 'GENERATED ALWAYS AS %ls' column '%.*ls' can only be nullable. 37349 16 No LEDGER = ON cannot be specif

Description 37365 16 No The '%s' parameter provided for ledger verification cannot be null.

Description 37383 16 No Enabling Change Tracking for ledger history table '%.*ls' is not allowed. 37384 16 No Table '%.*ls' is a FileTable. LEDGER = ON cannot be used on FileTables. 37385 16 No LEDGER

Description 37402 16 No Setting LEDGER to ON failed because ledger view '%.*ls' is not specified in two-part name format.

Description 37422 16 Yes Error occurred while reading STS Url. 37423 16 Yes Error occurred while fetching the external access policies. Please check if Managed System Identity is enabled on the server

Description 37439 16 No The statement failed because a nonclustered index cannot be created on table '%.*ls' that is a ledger table and has a clustered columnstore index.

Description 37458 16 No Posted digest is not globally committed in Azure Confidential Ledger. Ledger URL '%ls' and error code %ld. 37459 16 No Encountered Internal Error while calling Azure Confidenti

Description 37474 16 No The target table '%.*ls' provided to 'sp_copy_data_in_batches' cannot have a disabled clustered index. 37475 16 No The target table '%.*ls' provided to 'sp_copy_data_in_batches

Description 37488 16 No The source and target tables provided to 'sp_copy_data_in_batches' cannot contain columns of data type text, ntext, image or with the ROWGUIDCOL or FILESTREAM attributes. 37489

Description 37503 16 No The column '%.*ls' on ledger table '%.*ls' cannot be dropped because it is an identity or computed column. 37504 10 No Failed to convert string to guid when fetching tenantID f

Description 37520 16 Yes Error retrieving IMDS endpoint. 37521 16 No Geo-replication cannot be stopped because the database has Ledger Digest Uploads enabled. Disable Ledger Digest Uploads and retry t

Description 37535 16 No Principal name with object id '%ls' must begin with the original principal name followed by a user-defined suffix to differentiate between the names.

Description provider, or alter the AAD group to assign the DEFAULT_SCHEMA as dbo, then rerun the statement.

Description 37561 16 No Database encryption key cannot be altered because the database is not encrypted. 37562 16 No When key change is in progress, only suspend and resume operations are allowed. 375

Description this issue, please see https://aka.ms/sqlmi-tde-troubleshooting . 37572 16 No Customer managed key '%s' was not found in Azure Key Vault '%s'.

Description failed to retrieve. [Error: %d]. 37608 16 Yes [Auditing][%ls][Informational] Xpath [%ls] for WinFab Property '[%ls]' under Namespace '[%ls]' failed to retrieve. [Error: %d]. 37609 16 Yes [

Description 39002 16 No SQL failed to boot extensibility for error code 0x%lx. 39003 10 No SQL successfully boots extensibility. 39004 16 No A '%.*s' script error occurred during execution of 'sp_exec

Description 39019 10 No An external script error occurred: %.*ls%.*ls 39020 16 No Feature 'Advanced Analytics Extensions' is not installed. Consult Books Online for more information on this feature. 3

Description 39039 16 No Error converting the parameter value for '%.*ls' to '%.*ls'. 39040 16 No The function '%ls' does not support SQL identifier or variable for '%.*ls'. 39041 16 No The parameter '

Description 39093 16 No 'PREDICT' function does not take parameters of varchar(max), nvarchar(max) or varbinary(max) type except for 'MODEL' parameter.

Description 39110 16 No Maximum number of concurrent external script queries for this user has been reached. Limit is %d. Please retry the operation. External script request id is %ls. 39111 16 No The

Description 39127 16 No External script execution for '%.*s' script ran out of resources. External script request id is: %s. 39128 16 No External language runtime for '%s' could not be provisioned. Er

Description 39146 16 No External stream '%s' has invalid properties. 39147 16 No Kafka datasource '%s' should specify a value for PARTITIONS in the properties field. 39148 16 No External file format '

Description 40013 16 No Replicated target schema %.*ls is not found. 40014 16 No Multiple databases can not be used in the same transaction. 40015 16 No This functionality is not supported on replicat

Description 40036 16 No Can not perform replica operation because this node is not the secondary for this partition. 40037 16 No The epoch being started must not have been used. The new CSN is (%d,%I6

Description 40060 16 No Attempt to replicate out of partition already locked for internal use. 40061 16 No Unknown rowset id. 40062 16 No Incorrect replica role transition.

Description 40082 16 No Induced exception for testing purposes. 40083 16 No Corrupted CSN vector. 40084 16 No Multiple modifications to CSN vector in the same transaction are not supported. 40085 16 N

Description 40105 16 No The local partition map for database %.*ls is starting up in reduced functionality mode because of log full.

Description 40140 16 No Set partition failed since a different partition already was set in the current transaction. Cross partition operations within a node are not reliable or supported. 40141 16 No

Description 40160 16 No Heartbeat message version mismatch. Actual version is %d and the expected is %d. 40161 16 No Invalid partition type. Only 1 or 2 is supported.

Description 40181 16 Yes Fabric-database ('%.*ls') cannot be paired, the supplied mutex ('%.*ls') could not be opened. Error code: %d 40182 16 Yes The schema scope %ld being created is not empty. 4018

Description 40202 16 No Corrupted composite message. 40203 16 No Could not register AsyncTransport endpoint.

Description 40404 16 No Error sending the streaming job request. 40405 16 No T-SQL streaming is not supported. 40406 16 No The sysadmin role is required for operations on T-SQL streaming jobs. 40407 1

Description 40513 16 No Server variable '%.*ls' is not supported in this version of SQL Server. 40514 16 No '%ls' is not supported in this version of SQL Server. 40515 16 No Reference to database and/

Description 40533 16 No Server '%.*ls' already exists. 40534 16 No A valid SID is already associated with the database owner. 40535 16 No Properties for schema scope '%.*ls' already exist. 40536 16 No

Description 40553 16 No The session has been terminated because of excessive memory usage. Try modifying your query to process fewer rows. 40554 10 No Exiting because of XEvent %ls. 40555 16 No '%ls'

Description 40573 16 No Cannot upgrade CloudDB auto partitions in database '%.*ls' because the physical database is read only.

Description 40601 16 No Server Admin user already exists. 40602 16 No Could not create login. Please try again later. 40603 16 No Cannot execute procedure because current user is not Gateway. 40604 16

'Description 40621 16 No metric type 40622 16 No metric data 40623 20 No Reauthentication failed for login "%.*ls". Within the past reauthentication interval, the login has become invalid due to a pass'

Description 40638 16 No Invalid subscription id '%.*ls'. Subscription does not exist. 40639 16 No Request does not conform to schema: %.*ls. 40640 20 No The server encountered an unexpected exception.

Description 40660 16 No Could not successfully restore database. This request has been assigned a tracing ID of '%.*ls'. Provide this tracing ID to customer support when you need assistance. 40661 16

Description 40678 16 No Invalid value for header '%.*ls'. The header must contain a single valid GUID.

Description 40695 16 No The operation cannot be performed since the database is currently a Federation root or member database.

Description 40719 16 No Failed to get %s lock on %s rules. 40720 16 No Rule name '%.*ls' already exists. 40721 16 No Only one of inputtype, isnull and format attributes is required in %.*ls. 40722 16

Description 40814 16 No Could not change database edition to or from Premium for a Federation root. 40815 16 No Could not change database edition to or from Premium for a Federation member. 40816 16 N

Description 40843 16 No Non-readable secondary is not supported for database copy. 40844 16 No Database '%ls' on Server '%ls' is a '%ls' edition database in an elastic pool and cannot have a replicati