SQL Server Errors or Failures from Error: 21888 to Error: 22108

SQLServerF1

 

Error: 21888, Severity: 16, The SQL Server instance ‘%s’ is not configured to support replication. To enable the SQL Server instance to serve as a replication publisher, configure the instance for replication.
Error: 21889, Severity: 16, The SQL Server instance ‘%s’ is not a replication publisher. Run sp_adddistributor on SQL Server instance ‘%s’ with distributor ‘%s’ in order to enable the instance to host the publishing database ‘%s’. Make certain to specify the same login and password

Error: 21890, Severity: 16, The SQL Server instance ‘%s’ with distributor ‘%s’ and distribution database ‘%s’ cannot be used with publisher database ‘%s’. Reconfigure the publisher to make use of distributor ‘%s’ and distribution database ‘%s.
Error: 21891, Severity: 16, The publisher ‘%s’ with distributor ‘%s’ is not known as a publisher at distributor ‘%s’. Run sp_adddistpublisher at distributor ‘%s’ to enable the remote server to host the publishing database ‘%s’.
Error: 21892, Severity: 16, Unable to query sys.availability_replicas at the availability group primary associated with virtual network name ‘%s’ for the server names of the member replicas: error = %d, error message = %s.’,

Error: 21893, Severity: 16, The subscribers ( %s ) of original publisher ‘%s’ do not appear as remote servers at redirected publisher ‘%s’. Run sp_addlinkedserver at the redirected publisher to add these subscribers as remote servers.
Error: 21894, Severity: 16, Unable to configure a linked server to query replica host server ‘%s’: return code = %d.
Error: 21895, Severity: 16, One or more publisher validation errors were encountered for replica host ‘%s’.
Error: 21896, Severity: 16, The query at the redirected publisher ‘%s’ to determine whether the SQL Server instance is a replication publisher failed with error ‘%d’, error message ‘%s’.
Error: 21897, Severity: 16, The query to determine whether the local distributor ‘%s’ is the distributor for remote publisher ‘%s’ failed with error ‘%d’, error message ‘%s’.
Error: 21898, Severity: 16, The publisher ‘%s’ uses distribution database ‘%s’ and not ‘%s’ which is required in order to host the publishing database ‘%s’. Run sp_changedistpublisher at distributor ‘%s’ to change the distribution database used by the publisher to ‘%s’.
Error: 21899, Severity: 16, The query at the redirected publisher ‘%s’ to determine whether there were sysserver entries for the subscribers of the original publisher ‘%s’ failed with error ‘%d’, error message ‘%s’.
Error: 22101, Severity: 16, The value supplied for the change_columns argument of CHANGE_TRACKING_IS_COLUMN_IN_MASK function is not valid. The value must be a bitmask returned by the CHANGETABLE(CHANGES …) function.
Error: 22102, Severity: 16, The arguments supplied are not valid for the CHANGES option of the CHANGETABLE function.
Error: 22103, Severity: 16, The arguments supplied are not valid for the VERSION option of the CHANGETABLE function.
Error: 22104, Severity: 16, A table returned by the CHANGETABLE function must be aliased.
Error: 22105, Severity: 16, Change tracking is not enabled on table ‘%.*ls’.
Error: 22106, Severity: 16, The CHANGETABLE function does not support remote data sources.
Error: 22107, Severity: 16, Object ‘%.*ls’ is of a data type that is not supported by the CHANGETABLE function. The object must be a user-defined table.
Error: 22108, Severity: 16, The CHANGE_TRACKING_CONTEXT WITH clause cannot be used with a SELECT statement.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *