SQL Server System Errors: 42000 - 45999

List of error messages between 42000 and 45999 in SQL Server 2017.

These error messages are all available by querying the sys.messages catalog view on the master database.

Filter by:

message_id	severity	text
42001	16	Failed to parse XML configuration. The operating system returned error %ls.
42002	16	Failed to parse XML configuration. The parser returned error %.*ls
42003	16	Failed to parse XML configuration. A required attribute '%ls' is missing.
42004	16	Failed to parse XML configuration. A required element '%ls' is missing.
42005	16	Failed to parse XML configuration. Invalid value for attribute '%ls'.
42006	16	The default tempdb directory ('%ls') in XDB is not a valid path.
42007	16	The default tempdb directory ('%ls') in XDB is not a local path.
42008	16	ODBC error: State: %ls: Error: %d Message:'%ls'.
42009	16	Instance certificate '%ls' cannot be found.
42010	16	Cannot initiate cross instance connection.
42011	16	ODBC initialization error: : %d.
42012	16	XodbcWrapper Enforced Retry For Testing.
42013	16	HTTP initialization error: : %d.
42014	16	Cannot retrieve server admin credential configuration.
42015	20	Error occurred while attempting to authenticate user remotely. Error %d, State %d.
42016	16	Error occurred in the DosGuard.
42017	16	Error occurred in the Redirector's proxy while parsing a packet. Expected: %d, Actual: %d.
42018	16	Remote transaction has been doomed and cannot commit.
42019	16	%ls operation failed. %ls
42020	16	Updating name to '%.*ls' failed.
42021	16	Initialization of http session handle for fetching federation metadata failed during AzureActiveDirectory initialization.
42022	16	Initialization of http connect handle for fetching federation metadata failed during AzureActiveDirectory initialization.
42023	16	Updating userdb properties on copy termination failed.
42024	16	Switching to logical master database failed.
42025	16	The extended recovery fork stack in the metadata of FCB is either corrupted or in an unexpected format.
42026	16	Loading the Active Directory Library failed.
42027	16	Initialization of the Active Directory Function pointers failed.
42028	16	The database '%.*ls' has been detached as it was marked as a shared disk instance and was not started. This is an informational message; no user action is required.
42029	16	An internal error happened while generating a new DBTS for database "%.*ls". Please retry the operation.
42030	16	Updating logical master's sys.databases on seeding completion failed.
42031	16	This functionality is not supported for A/B test isolated instances.
42032	16	XODBC Get Authentication Cache failed, state %d
42033	16	Updating Layered AG Configuration failed.
43001	16	'%.*ls' is not a valid login name.
43002	16	Storage in MB %d exceeds the maximum limit %d.
43003	16	More than one firewall rules have the same name '%.*ls'.
43004	16	'%.*ls' is not a valid firewall rule name because it contains invalid characters.
43005	16	'%.*ls' is not a valid database name because it contains invalid characters.
43006	16	Database name '%.*ls' is too long.
43007	16	'%.*ls' is not a valid database charset.
43008	16	'%.*ls' is not a valid database collation.
43009	16	Storage in MB %d is below the minimum limit.
43010	16	'%.*ls' cannot be updated.
43011	16	'%.*ls' is not a valid version.
43012	16	The configuration name cannot be empty.
43013	16	The value for configuration '%.*ls' cannot be empty.
43014	16	The same configuration '%.*ls' cannot be updated more than once.
43015	16	The configuration '%.ls' does not exist for %.ls server version %.*ls.
43016	16	The value '%.ls' for configuration '%.ls' is not valid. The allowed values are '%.*ls'.
43017	16	The configuration names you defined are not consistent.
43018	16	The value '%.ls' for configuration '%.ls' is not consistent with default value '%.*ls'.
43019	16	The source '%.ls' for configuration '%.ls' is not valid.
45001	16	%ls operation failed. Specified federation name does not exist.
45002	16	%ls operation failed. Specified federation distribution name %.*ls is not valid.
45003	16	%ls operation failed. Specified data type is not supported as a federation distribution.
45004	16	%ls operation failed. Specified value is not valid for federation distribution %.ls and federation %.ls.
45005	16	Filter value cannot be set or was already set for this session.
45006	16	The federation key value is out of bounds for this member.
45007	16	%ls cannot be run while another federation operation is in progress on federation %.*ls and member with id %d.
45008	16	A partition in a table group that has a partition key defined is not allowed to be a federation member.
45014	16	%ls is not supported on %S_MSG.
45015	16	Specified federation operation id is already in use.
45016	16	Specified federation %.*ls does not exist.
45017	16	%ls operation failed. Specified federation name %.*ls is not valid.
45018	16	Specified federation operation id is invalid for %ls operation.
45019	16	%ls operation failed. Federation is in invalid state.
45020	16	%ls operation failed. %d is not a valid federation id.
45021	16	%ls operation failed. %d is not a valid federation member id.
45022	16	A column insert or update conflicts with a federation member range. The statement was terminated. The conflict occurred in database '%.ls', table '%.ls', column '%.*ls'.
45023	16	%ls cannot be called on %S_MSG.
45024	16	ALTER FEDERATION SPLIT operation failed. Specified boundary value already exists for federation distribution %.ls and federation %.ls.
45025	16	%ls operation failed. Specified boundary value is not valid for federation distribution %.ls and federation %.ls.
45026	16	%ls operation failed. Specified boundary value does not exist for federation distribution %.ls and federation %.ls.
45027	16	%ls operation failed. Specified type information is not valid for federation distribution.
45028	16	%ls operation failed. Specified boundary value is not valid for current federation member.
45029	16	%ls operation failed. The federation distribution scheme size cannot exceed 900 bytes.
45030	15	The USE FEDERATION statement is missing the required %.*ls option. Provide the option in the WITH clause of the statement.
45031	16	The USE FEDERATION statement is not supported on a connection which has multiple active result sets (MARS) enabled.
45032	16	The USE FEDERATION statement is not allowed under non-revertible impersonated security context.
45033	16	Federation member %d is not available. Another command is creating or dropping it.
45034	16	Federation member database cannot be dropped using DROP DATABASE.
45035	16	Federation member database cannot be renamed using ALTER DATABASE.
45036	16	ALTER FEDERATION SPLIT operation has been aborted. The %.*ls federation was dropped while the split was still in progress.
45037	16	ALTER FEDERATION SPLIT operation failed due to an internal error. This request has been assigned a tracing ID of '%.*ls'. Provide this tracing ID to customer support when you need assistance.
45038	16	CREATE DATABASE AS COPY OF %S_MSG is not supported.
45039	16	Federation member database cannot be restored.
45040	16	Service objective for federation member database cannot be changed using ALTER DATABASE.
45041	16	Federation member database options cannot be changed.
45042	16	Federation root database options cannot be changed.
45043	16	ALTER FEDERATION SWITCH %ls is not supported on %ls members.
45044	16	ALTER FEDERATION SWITCH IN failed. %.*ls is not a valid database that can be switched in.
45045	16	ALTER FEDERATION SWITCH IN failed. %ls of the federation key in %.ls doesn't match with the correponding property of federation %.ls.
45046	16	%ls operation failed. The specified value for federation %.*ls does not correspond to a present member.
45101	16	Parameter "%ls" should contain all configurable dimension properties.
45102	16	Parameter "%ls" should contain settings for all dimensions.
45103	16	Cannot reset the last setting for a dimension to non-default.
45104	16	The default setting cannot be deleted for a dimension.
45105	16	Cannot assign a deprecated setting as successor.
45106	16	Cannot create new item. The max provision count has been reached.
45107	16	Cannot reset service objective to draft from enabled or disabled state.
45108	16	Default service objective cannot be disabled.
45109	16	Parameter "%ls" contains conflicting dimension setting selections.
45110	16	Parameter %s value cannot be applied to service objective in non-draft mode.
45111	16	Cannot reset the last service objective to non-default.
45112	16	Cannot delete the default service objective.
45113	16	Cannot set the service objective as default in draft mode.
45114	16	Cannot edit setting marked as deprecated.
45115	16	Cannot assign a disabled service objective to a database.
45116	16	Cannot delete a setting without a successor assigned for deprecation.
45117	16	Cannot delete a system service objective.
45118	16	Cannot assign a system service objective to user database.
45119	16	Property selections contain conflicting values.
45120	16	The name '%ls' already exists. Choose a different name.
45121	16	Server '%ls' does not support memory-optimized data. Make sure both source and target servers are enabled for memory-optimized data.
45122	16	'%ls'
45125	16	Parameter "%ls" cannot be empty or null.
45126	16	Parameter "%ls" is invalid.
45127	16	Parameter "%ls" is invalid.
45128	16	Parameter "%ls" is invalid.
45129	16	Parameter "%ls" is invalid.
45130	16	Parameter "%ls" is invalid.
45131	16	Parameter "%ls" is invalid.
45132	16	Every database must be assigned a service objective.
45133	17	A connection failed while the operation was still in progress, and the outcome of the operation is unknown. Query sys.dm_operation_status in the master database for current job status.
45134	16	The remote partner server name '%ls' could not be resolved.
45135	16	Only continuous database copies can be updated.
45136	16	Only continuous database copies can be terminated.
45137	16	Insufficient permission to create a database copy on server '%ls'.
45138	16	The destination database name '%ls' already exists on the server '%ls'.
45139	16	The source server name should be the server of the current connection.
45140	16	Maximum lag does not support the specified value. Maximum lag must be between '%ls' and '%ls'.
45141	16	Database copies can only be initiated on the source server.
45142	16	IsForcedTerminate cannot be set while creating a database copy. This can only be updated on the source server after it is created.
45143	16	The source database '%ls' does not exist.
45144	16	Continuous copy cannot be initiated on source database '%ls' because it is a federation root member.
45145	16	Only continuous database copies can be created.
45146	16	Database copy property '%ls' is required.
45147	16	Database copy property '%ls' cannot be changed.
45148	16	'%ls' is not supported for entity '%ls'.
45149	16	Continuous copy is not supported on 'master' database.
45150	16	Feature is disabled.
45151	16	Changing value(s) '%ls' for entity '%ls' not supported.
45152	16	Termination of a database copy cannot be performed because the destination server '%ls' is unavailable or the database copy does not exist on the destination server. Try forced termination instead.
45153	16	Management Service is not currently available. Please retry the operation later. If the problem persists, contact customer support, and provide them the session tracing ID of '%ls'.
45154	16	A free database already exists for subscription '%ld' for the selected region. Subscription can have only one free database per region. To provision another free database in same subscription, choose a different region. To provision another free database in same region, use different subscription.
45155	16	A free database operation is already in progress for subscription '%ld'. Subscription can have only one free database per region. To provision another free database in same subscription, choose a different region. To provision another free database in same region, use different subscription.
45156	16	Subscription '%.*ls' is busy with another operation. Please try your operation later.
45157	16	Server '%.*ls' is busy with another operation. Please try your operation later.
45158	16	Cannot move server '%.*ls' from source subscription '%ls' to target subscription '%ls'. You can have only one free database per subscription. To continue the move operation, drop one of the free databases, or use a different subscription.
45159	16	Cannot move servers from source subscription '%ls' to target subscription '%ls' since both subscriptions have free databases. You can have only one free database per subscription. To continue the move operation, drop one of the free databases, or use a different subscription.
45160	16	Subscription '%ls' doesn't have any servers to move.
45162	16	Operation failed because subscription '%ls' is disabled.
45163	16	Create Server request must either specify SQL login with password or denote admin login is a federated user by setting 'IsFederatedAdminLogin' property to 'True'.
45164	16	Invalid number of database copies: '%d'. Only one database copy is currently allowed to be created along with the database creation.
45165	16	Continuous copy is not supported on the free database '%.*ls'.
45166	16	Database '%.ls' was %.ls successfully, but some properties could not be displayed.
45167	16	An invalid state transition was attempted.
45168	16	The server '%.*ls' has too many active connections. Try again later.
45169	16	The subscription '%.*ls' has too many active connections. Try again later.
45170	16	A trusted certificate was not found for this request.
45171	16	Secondary database must be created in the same server as primary database unless 'IsContinuous' is specified.
45172	16	The 'MaximumLag' parameter requires that 'IsContinuous' is specified.
45173	16	Source server not found for subscription: %ls, resource group: %ls, server name: %ls.
45174	16	Unable to queue server %ls for migration. There is a pending migration request for the server.
45175	16	Unable to queue server %ls for migration. A migration is already in progress.
45176	16	Unable to queue server %ls for migration. The server is using feature %ls that prevents it from being migrated.
45177	16	Unable to queue server %ls for migration. Failed to find a target cluster for migration.
45178	16	Database create mode '%ls' is not supported.
45179	16	The operation timed out and automatically rolled back. Please retry the operation.
45180	16	Resource with the name '%ls' already exists. To continue, specify a different resource name.
45181	16	Resource with the name '%ls' does not exist. To continue, specify a valid resource name.
45182	16	Database '%ls' is busy with another operation. Please try your operation later.
45183	16	There is an import or export operation in progress on the database '%ls'.
45184	16	Operation Id '%ls' was not found.
45185	16	The change role completion notification for logical server '%.*ls', ag id '%ls', local database id '%ls' was ignored as freshness number did not match. Expected '%d'.
45186	16	Database create mode '%ls' is not supported in state '%ls'.
45187	16	The replication mode updated notification for logical server '%.*ls', ag id '%ls', local database id '%ls', partner database id '%ls' was ignored as current replication mode did not match expected value '%ls'.
45188	16	The operation has been cancelled by user.
45189	16	Insufficient permission to add secondary on server '%ls'.
45190	16	'%ls' is an invalid name because it contains one or more unsupported unicode characters.
45191	16	The operation could not be completed because it would result in data loss on secondary database '%ls' on server '%ls.' Set the 'replace' parameter to proceed anyway.
45192	16	The value specified for 'allow_connections' does not match the value for the existing replication relation for database '%ls' on server '%ls.'
45193	16	Database '%ls' on server '%ls' is already the target in another replication relationship.
45194	16	The operation could not be completed because it would result in target database '%ls' on server '%ls' having a lower service objective than source database '%ls' on server '%ls.'
45195	16	The operation could not be completed because database '%ls' on server '%ls' is the source in another replication relationship.
45196	16	The operation on the resource could not be completed because it was interrupted by another operation on the same resource.
45197	17	A system maintenance operation is in progress on server '%.ls' and database '%.ls.' Please wait a few minutes before trying again.
45198	16	MODIFY LOG FILE failed. Size is greater than MAXSIZE.
45199	16	This command requires a database encryption scan on database '%.*ls'. However, the database has changes from previous encryption scans that are pending log backup. Please wait several minutes for the log backup to complete and retry the command.
45200	16	The server '%ls' are not associated with the tenant '%ls'.
45201	16	SQL Server Agent service is not running.
45202	16	Timed out after %ld seconds waiting for Smart Admin job to complete. Please run the stored procedure again.
45203	16	The parameter @state cannot be NULL, and should be 1 or 0. Specify 1 to start SQL Server Managed Backup to Windows Azure, or 0 to pause.
45204	16	The parameter %ls cannot be NULL or empty. Provide a valid %ls.
45205	16	No backup setting is supplied. Please specify at least one backup setting to be configured.
45206	16	The value specified for parameter @type is invalid. The @type parameter value should either be 'Database' or 'Log'.
45207	16	%ls
45208	16	SQL Server Managed Backup to Windows Azure master switch is not turned on.
45209	16	The parameter value for notification email is not specified or is NULL. Please specify a valid email to enable notifications for Smart Admin.
45210	16	Database Mail is not enabled for SQL Agent to use for Notifications. Enable Database Mail as the mail system for alerts.
45211	16	Database mail profile is not setup for SQL Agent notifications.
45212	16	The value specified for parameter %ls is invalid. Provide a valid %ls.
45213	16	@full_backup_freq_type, @backup_begin_time, @backup_duration, and @log_backup_freq must be specified if @scheduling_option is set to 'Custom'
45214	16	@days_of_week must be specified if @full_backup_freq_type is set to 'Weekly'
45215	16	Local caching is not yet supported.
45216	16	@full_backup_freq_type, @backup_begin_time, @backup_duration, and @log_backup_freq must not be specified if @scheduling_option is set to 'System'
45217	16	@encryptor_type, and @encryptor_name must not be specified if @encryption_algorithm is set to 'NO_ENCRYPTION'
45218	16	@encryptor_type, and @encryptor_name must be specified if @encryption_algorithm is not set to 'NO_ENCRYPTION'
45219	16	@days_of_week must not be specified if @full_backup_freq_type is set to 'Daily'
45220	10	An error occurred while configuring for the SQL Agent: error %d, severity %d, state %d.
45221	10	An error occurred while configuring for the SQL Agent: error %d, severity %d, state %d.
45301	17	The resource has been moved to another location
45302	17	SLO '%ls' operation cannot succeed as the memory usage of '%ls' exceeds the quota.
45303	17	Attempt to cancel activation or rollback activation automatically because of operation timeout, but this is not supported in current state. Please check database status after operation is finished.
45304	16	Elastic pool estimate '%.ls' was not found for server '%.ls'
45305	16	Request could not be processed because of conflict in the request: '%.*ls'
45306	16	The external admin cannot be set because the user or group already exists in the 'master' database.
45307	16	Advisor '%.*ls' was not found for requested resource
45308	16	Recommended action '%.ls' was not found for advisor '%.ls'
45309	16	The operation could not be completed because database '%ls' on server '%ls' is recovering from a geo-replication role change and is not currently eligible to become a primary or standalone database. Wait until the relationship leaves the 'SUSPENDED' replication state and try again.
45310	16	Unable to return metrics. Request would return too much data.
45311	16	The server key '%.*ls' already exists. Please choose a different server key name.
45312	16	The server key URI '%.*ls' already exists as another server key.
45313	16	The server key '%.ls' cannot be deleted because it is currently in use by '%.ls'.
45314	16	Server key '%.*ls' does not exist. Make sure that the server key name is entered correctly.
45315	16	The operation could not be completed because a service objective assignment is in progress for database '%.ls' on server '%.ls.' Wait for the service objective assignment to complete and try again.
45316	16	MODIFY FILE failed. Size is greater than MAXSIZE. Please query sys.database_files and use DBCC SHRINKFILE to reduce the file size first.
45317	16	Server '%.ls' does not exist in resource group '%.ls' in subscription '%.*ls'.
45318	16	Service Fabric Application Version is not available.
45319	16	The service objective assignment for database '%.ls' on server '%.ls' could not be completed as the database is too busy. Reduce the workload before initiating another service objective update.
45320	16	The operation could not be completed on server '%.ls' because the Azure Key Vault key '%.ls' is disabled.
45321	16	The operation could not be completed on server '%.ls' because attempts to connect to Azure Key Vault '%.ls' have failed
45322	16	The operation could not be completed because the Azure Key Vault key '%.*ls' expiration date is invalid.
45323	16	Unable to start a copy because the source database '%ls' is being updated.
45324	16	The operation could not be completed because the Azure Key Vault Uri is null or empty.
45325	16	The operation could not be completed because the Azure Key Vault Key name is null or empty.
45326	16	The operation could not be completed because the Azure Key Vault Key name '%ls' does not exist.
45327	16	The operation could not be completed because the Azure Key Vault Key name '%ls' is currently set as server encryption protector.
45328	16	The server identity is not correctly configured on server '%ls'. Please contact support.
45329	16	An invalid response from Azure Key Vault. Please use a valid Azure Key Vault URI.
45330	16	The server '%ls' requires the following Azure Key Vault permisions: '%ls'. Please grant the missing permissions to the service principal with ID '%ls'.
45331	16	The operation could not be completed because the read scale value specified is not supported for a '%ls' database.
45332	16	The operation could not be completed because the read scale value specified is invalid.
45333	16	The service request timed out. %ls.
45334	16	Server edition '%ls' is invalid.
45335	16	Server type '%ls' is invalid.
45336	16	The operation could not be completed because '%ls' is an invalid Server Key name. Please provide a key name in the format of 'vault_key_version'. For example, if the keyId is https://YourVaultName.vault.azure.net/keys/YourKeyName/01234567890123456789012345678901, then the Server Key Name should be formatted as: YourVaultName_YourKeyName_01234567890123456789012345678901.
45337	16	The planned failover operation has rolled back because database '%ls' could not be synchronized with its remote partner. This may be due to a service outage, or to a high volume of write traffic. Consider using forced failover.
45338	16	The planned failover operation has rolled back because the remote server '%ls' could not be reached. This may be due to a service outage. Consider using forced failover.
45339	16	The max size update on the geo-secondary database '%ls' on server '%ls' failed with reason '%ls'.
45340	16	The operation could not be completed because an Azure Active Directory error was encountered. The error message from Active Directory Authentication library (ADAL) is '%ls'.
45341	16	The operation could not be completed because an error was encountered when attempting to retrieve Key Vault information for '%ls' from server '%ls'. The encountered error message is '%ls'.
45342	16	The operation could not be completed because an Azure Active Directory error was encountered. Please ensure the server '%ls' and key vault '%ls' belong to the same tenant. The error message from Active Directory Authentication library is '%ls'.
45343	16	The provided Key Vault uri '%ls' is not valid. Please ensure the uri contains the vault, key, and key version information. An example valid uri looks like 'https://YourVaultName.vault.azure.net/keys/YourKeyName/01234567890123456789012345678901'. Please ensure the vault belongs to an endpoint from the list of supported endpoints available at '%ls'.