SQL Server Errors or Failures from Error: 14071 to Error: 14099

 

Error: 14071, Severity: 16, Could not find the Distributor or the distribution database for the local server. The Distributor may not be installed, or the local server may not be configured as a Publisher at the Distributor.
Error: 14074, Severity: 16, The server ‘%s’ is already listed as a Publisher.
Error: 14075, Severity: 16, The Publisher could not be created at this time.
Error: 14076, Severity: 16, Could not grant replication login permission to ‘%s’.
Error: 14077, Severity: 10, The publication was updated successfully.
Error: 14078, Severity: 16, The parameter must be ‘description’, ‘taskid’, ‘sync_method’,

‘status’, ‘repl_freq’, ‘restricted’, ‘retention’, ‘immediate_sync’, ‘enabled_for_internet’, ‘allow_push’, ‘allow_pull’, ‘allow_anonymous’, or ‘retention’.
Error: 14080, Severity: 16, The remote server “%s” does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available Publishers.
Error: 14085, Severity: 16, The Subscriber information could not be obtained from the Distributor.
Error: 14088, Severity: 16, The table ‘%s’ must have a primary key to be published using the transaction-based method.
Error: 14089, Severity: 16, The clustered index on materialized view ‘%s’ may not contain nullable columns if it is to be published using the transaction-based method.
Error: 14090, Severity: 16, Error evaluating article synchronization object after column drop. The filter clause for article ‘%s’ must not reference the dropped column.

Error: 14091, Severity: 16, The @type parameter passed to sp_helpreplicationdb must be either ‘pub’ or ‘sub’.
Error: 14092, Severity: 16, Could not change article because there is an existing subscription to the article.
Error: 14093, Severity: 16, Cannot grant or revoke access directly on publication ‘%s’ because it uses the default publication access list.
Error: 14094, Severity: 16, Could not subscribe to article ‘%s’ because heterogeneous Subscriber ‘%s’ does not support the @pre_creation_cmd parameter value ‘truncate’.
Error: 14095, Severity: 16, The value for the @sync_method parameter is not valid. Could not subscribe to publication ‘%s’ because non-SQL Server Subscriber ‘%s’ only supports values of ‘character’, ‘bcp character’, ‘concurrent_c’, and ‘database snapshot character’ for the @sync_me
Error: 14096, Severity: 16, The path and name of the table creation script must be specified if the @pre_creation_cmd parameter value is ‘drop’.
Error: 14097, Severity: 16, The ‘status’ value must be ‘no column names’, ‘include column names’, ‘string literals’, ‘parameters’, ‘DTS horizontal partitions’ or ‘no DTS horizontal partitions’.
Error: 14098, Severity: 16, Cannot drop Distribution Publisher ‘%s’. The remote Publisher is using ‘%s’ as Distributor. Disable publishing at the Publisher before attempting to drop this relationship.
Error: 14099, Severity: 16, The server ‘%s’ is already defined as a Distributor. To reconfigure the server as a Distributor, you must first uninstall the exisiting Distributor. Use the stored procedure sp_dropdistributor, or use the Disable Publishing and Distribution Wizard.

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.