Event ID - 14117

Event Id14117
SourceMSSQLServer
Description%s is not configured as a distribution database.
Event InformationCAUSE:
This error can occur if any one or more of the following are true:
There is no entry for the local server in the sysservers table in the master database, or the entry is incorrect. To verify the local server setting, connect to the local server and run "select @@servername" from Query Analyzer. If a (NULL) is returned, an entry for the local server does not exist in the sysservers table in the master database. If a value other than the Computer Name or SQL Virtual Name is returned, the entry is incorrect, perhaps because the computer was renamed. Note that a restart of SQL Server is required for changes to the local server to be reflected in @@servername.
The entry for the specified distribution database is missing from msdb..MSdistributiondbs.
The replication bitmap stored in the category column of sysdatabases does not reflect that the specified database is used for distribution.

RESOLUTION:
Follow these steps:
A. 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 Name rather than the node name, and the SQL Virtual 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 or is NULL for a nonclustered instance, follo
Reference LinksMicrosoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 14117

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.