SQL Server Errors or Failures from Error: 20807 to Error: 21008
Error: 20807, Severity: 16, No peers were found for %s:%s:%s. If you encounter this error when executing the stored procedure sp_requestpeerresponse, verify that subscriptions have been created before attempting to call the procedure again. If you encounter this error in other circu
Error: 20808, Severity: 16, The peer-to-peer publication ‘%s’ does not exist. Execute sp_helppublication to view a list of publication names.
Error: 20809, Severity: 16, Peer-To-Peer topologies require identical publication names on each publisher. The distribution agent for publication [%s].[%s].[%s] is attempting to synchronize articles that exist in publication [%s].[%s].[%s].
Error: 20810, Severity: 16, The specified source object must be a user-defined aggregate object if it is published as an ‘aggregate schema only’ type article.
Error: 20811, Severity: 16, Replication monitoring refresher for %s.
Error: 20812, Severity: 16, The specified source object must be a synonym if it is published as a ‘synonym schema only’ type article.
Error: 20813, Severity: 16, Only members of the sysadmin fixed server role can modify a %s that does not have a job with a proxy account defined.
Error: 20814, Severity: 10, Distribution Profile for OLEDB streaming
Error: 20815, Severity: 10, Distribution agent profile enabled for the processing LOB data using OLEDB streaming.
Error: 20816, Severity: 10, Peer-To-Peer publishers are only supported on Enterprise class editions of SQL Server. This instance is %s.
Error: 20817, Severity: 16, An error occurred during the execution of ‘%ls’. A call to ‘%ls’ failed with error code: ‘%ld’, return code: ‘%d’.
Error: 21000, Severity: 16, Cannot subscribe to an inactive publication.
Error: 21001, Severity: 16, Cannot add a Distribution Agent at the Subscriber for a push subscription.
Error: 21002, Severity: 16, The Distribution Agent for this subscription already exists (%s).
Error: 21003, Severity: 16, Changing publication names is no longer supported.
Error: 21004, Severity: 16, Cannot publish the database object ‘%s’ because it is encrypted.
Error: 21005, Severity: 10, For backward compatibility, sp_addpublisher can be used to add a Publisher for this Distributor. However, sp_adddistpublisher is more flexible.
Error: 21006, Severity: 16, Cannot use sp_addpublisher to add a Publisher. Use sp_adddistpublisher.
Error: 21007, Severity: 16, Cannot add the remote Distributor. Make sure that the local server is configured as a Publisher at the Distributor.
Error: 21008, Severity: 16, Cannot uninstall the Distributor because there are Subscribers defined.
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.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.