BUG: SQLExec Account > 30 Chars Can Cause AV in Repl Tasks |
Q150262
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.
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.
Use an account for SQLExecutive so that the account name returned from sp_helpdistributor does not exceed 30 characters.
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
|
Last Reviewed: March 27, 1999 © 2001 Microsoft Corporation. All rights reserved. Terms of Use. |