BUG: SQLExec Account > 30 Chars Can Cause AV in Repl Tasks

ID: Q150262

The information in this article applies to:

Microsoft SQL Server version 6.0

BUG#: 13678 (6.00)

SYMPTOMS

If the account name for SQLExecutive as returned by sp_helpdistributor exceeds 30 characters, the LogReader and SYNC task can fail with an access violation. An error is reported in the Event Log as:

Event ID: 212 Source: SQLExecutive Category: Task Engine
Event 2 - <task name> has caused an exception violation in the
<LogReader or SYNC> subsystem, and has been terminated.

CAUSE

The problem should only occur if SQLExecutive is logged on with a domain account, because local accounts are returned in sp_helpdistributor with a ".\" proceeding the account name, and local accounts can only be maximum 20 characters in length.

WORKAROUND

Use an account for SQLExecutive so that the account name returned from sp_helpdistributor does not exceed 30 characters.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem has been corrected in Microsoft SQL Server 6.5. For more information, contact your primary support provider.


Keywords          : kbprg SSrvErr_Log SSrvProg kbbug6.00 
Version           : 6.0 6.5
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 25, 1999