SQL Server Errors or Failures from Error: 21105 to Error: 21124

SQLServerF1

 

Error: 21105, Severity: 16, This edition of SQL Server cannot act as a Publisher or Distributor for replication.
Error: 21106, Severity: 16, This edition of SQL Server does not support publications.
Error: 21107, Severity: 16, ‘%ls’ is not a table or view.
Error: 21108, Severity: 16, This edition of SQL Server does not support transactional publications.
Error: 21109, Severity: 16, The parameters @xact_seqno_start and @xact_seqno_end must be identical if @command_id is specified.

Error: 21110, Severity: 16, @xact_seqno_start and @publisher_database_id must be specified if @command_id is specified.
Error: 21111, Severity: 16, ‘%s’ is not a valid parameter for the Snapshot Agent.
Error: 21112, Severity: 16, ‘%s’ is not a valid parameter for the Log Reader Agent.
Error: 21113, Severity: 16, ‘%s’ is not a valid parameter for the Distribution Agent.
Error: 21114, Severity: 16, ‘%s’ is not a valid parameter for the Merge Agent.
Error: 21115, Severity: 16, %d is not a valid value for the ‘%s’ parameter. The value must be a positive integer.

Error: 21116, Severity: 16, ‘%s’ is not a valid value for the ‘%s’ parameter. The value must be 1, 2, or 3.
Error: 21117, Severity: 16, ‘%s’ is not a valid value for the ‘%s’ parameter. The value must be 0, 1, or 2.
Error: 21118, Severity: 16, ‘%s’ is not a valid value for the ‘%s’ parameter. The value must be greater than or equal to 0 and less than or equal to 10,000.
Error: 21119, Severity: 16, %s is not a valid value for the ‘%s’ parameter. The value must be a non-negative integer.
Error: 21120, Severity: 16, Only members of the sysadmin fixed server role or db_owner fixed database role, or the owner of the subscription can drop subscription ‘%s’ to publication ‘%s’.
Error: 21121, Severity: 16, Only members of the sysadmin fixed server role and ‘%s’ can drop the pull subscription to the publication ‘%s’.
Error: 21122, Severity: 16, Cannot drop the distribution database ‘%s’ because it is currently in use.
Error: 21123, Severity: 16, The agent profile ‘%s’ could not be found at the Distributor.
Error: 21124, Severity: 16, Cannot find the table name or the table owner corresponding to the alternative table ID(nickname) ‘%d’ in sysmergearticles.

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 *