Event ID - 14071

Event Id14071
SourceMSSQLServer
DescriptionCould 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.
Event InformationCAUSE:
This message either indicates that replication is not properly configured or that the name specified as the server name for the Publisher, Distributor, or Subscriber is not the same as the local SQL Server instance name. This could occur because @@SERVERNAME was not updated after a computer rename, replication was previously incompletely removed, or the Distributor has not been properly configured for the specified Publisher.

RESOLUTION:
Use sp_helpdistributor on your Distributor instance to verify that the SQL Server instance is configured as a Distributor. A Distributor can be configured through the Replication tools in SQL Enterprise Manager or with the sp_adddistributor stored procedure.
Use sp_helpsubscriberinfo on the Publisher to verify that the Publisher and Subscriber instances are configured for their expected roles.

For each server involved in this replication topology, verify that the value of @@SERVERNAME is correct. Execute "SELECT @@SERVERNAME" and "EXEC master..xp_cmdshell set computername". When set computername is executed from Query Analyzer or OSQL for a clustered instance, it returns the SQL virtual server name rather than the node name, and the SQL virtual server name is the value needed for replication.

---1.For a nonclustered default instance, "SELECT @@SERVERNAME" should return the same value as "EXEC master..xp_cmdshell set computername".
---2. For a nonclustered named instance, "SELECT @@SERVERNAME" should return the value as "EXEC master..xp_cmdshell set computername" plus "\" plus the name of the instance.
---3. For a clustered default instance, "SELECT @@SERVERNAME" should return the same value as "EXEC master..xp_cmdshell set computername".
---4. For a clustered named instance, "SELECT @@SERVERNAME" should return the value as "EXEC master..xp_cmdshell set computername" plus "\" plus the name of the instance.
If the value of @@SERVERNAME is not correct for a noncluster
Reference LinksMicrosoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 14071

Catch threats immediately

We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.

See what we caught

Did this information help you to resolve the problem?

Yes: My problem was resolved.
No: The information was not helpful / Partially helpful.