SQL Server Errors or Failures from Error: 21029 to Error: 21048

 

Error: 21029, Severity: 16, Cannot drop a push subscription entry at the Subscriber unless @drop_push is ‘true’.
Error: 21030, Severity: 16, Names of SQL Server replication agents cannot be changed.
Error: 21031, Severity: 16, ‘post_script’ is not supported for stored procedure articles.
Error: 21032, Severity: 16, Could not subscribe because non-SQL Server Subscriber ‘%s’ does not support ‘sync tran’ update mode.
Error: 21033, Severity: 16, Cannot drop server ‘%s’ as Distribution Publisher because there are databases enabled for replication on that server.

Error: 21034, Severity: 16, Rows inserted or updated at the Subscriber cannot be outside the article partition.
Error: 21035, Severity: 16, You have updated the Publisher property ‘%s’ successfully.
Error: 21036, Severity: 16, Another %s agent for the subscription or subscriptions is running, or the server is working on a previous request by the same agent.
Error: 21037, Severity: 16, Invalid working directory ‘%s’.

Error: 21038, Severity: 16, Windows Authentication is not supported by the server.
Error: 21039, Severity: 16, The article ‘%s’ contains the destination owner ‘%s’. Non-SQL Server Subscribers require articles to have the destination owner of NULL.
Error: 21040, Severity: 16, Publication ‘%s’ does not exist.
Error: 21041, Severity: 16, A remote distribution Publisher is not allowed on this server version.
Error: 21042, Severity: 16, The distribution Publisher property, ‘distributor_password’, has no usage and is not supported for a Distributor running on Windows NT 4.0.
Error: 21043, Severity: 16, The Distributor is not installed.
Error: 21044, Severity: 16, Cannot ignore the remote Distributor (@ignore_remote_distributor cannot be 1) when enabling the database for publishing or merge publishing.
Error: 21045, Severity: 16, Cannot uninstall the Distributor because there are databases enabled for publishing or merge publishing.
Error: 21046, Severity: 16, Cannot change distribution Publisher property ‘distribution_db’ because the Publisher is using the current distribution database.
Error: 21047, Severity: 16, Cannot drop the local distribution Publisher because there are Subscribers defined.
Error: 21048, Severity: 16, Cannot add login ‘%s’ to the publication access list because it does not have access to the distribution server ‘%s’.

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.