Event ID - 20089

Event Id20089
SourceMSSQLServer
DescriptionCould not get license information correctly.
Event InformationCAUSE:
This error occurs when a replication process, such as the Merge Agent, Distribution Agent, Log Reader Agent, or Snapshot Agent, cannot retrieve licensing information that determines whether the requested replication topology is allowed for the editions of SQL Server involved.
Commonly, this error is seen when xpsqlbot.dll or xpstar.dll cannot be loaded or when shared memory cannot be used to execute one of those DLLs.

If any of the computers involved are running SQL Server 7.0, the key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LicenseInfo\MSSQL7.00 may be missing for one or more of the computers or the key may not be accessible to the SQL Server Agent that is trying to read the key.

RESOLUTION:
Follow these steps:
1. Verify that xpsqlbot.dll exists in the binn directory where each SQL Server instance is installed. If the file does not exist, or if the file size and version do not match that on another SQL Server instance that is the exact same version, copy xpsqlbot.dll from an instance that does work.
2. In some cases a reboot of the machine may make the xpsqlbot.dll file available to the SQL Server instance.
3. If any of the machines in the replication topology are SQL Server 7.0 instances, verify that the key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LicenseInfo\MSSQL7.00 exists and that the SQL Server Agent startup account has full control over the key and all of its subkeys. If the key does not exist, copy it from a working copmuter and add the SQL Server Agent startup account with full control.
Reference LinksMicrosoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 20089

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.