Microsoft KB Archive/150262

{|
 * width="100%"|

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

 * }

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 - has caused an exception violation in the

 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 : kbprogramming

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600