RE: Distibution db cleanup will not run

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John (jpappas_at_rd.com)
Date: 02/03/04 

Date: Tue, 3 Feb 2004 08:41:51 -0800

Hi Baisong,

Here is the latest message from the agent history (it
looks like its the same as last time except the name of
the folder at the end has changed:

Executed as user: '@LOCAL_ACCT'. Could not remove
directory '\\SERVER_NAME\C$\MSSQL\Repl\unc\REPLICATION_NAME
_Tabl3d0a0ad\20040128210012\'. Check the security context
of xp_cmdshell and close other processes that may be
accessing the directory. [SQLSTATE 42000] (Error 20015)
Associated statement is not prepared [SQLSTATE HY007]
(Error 0) Replication-@rowcount_only parameter must be
the value 0,1, or 2. 0=7.0 compatible checksum. 1=only
check rowcou: agent distribution@rowcount_only parameter
must be the value 0,1, or 2. 0=7.0 compatible checksum.
1=only scheduled for retry. Could not clean up the
distribution transaction tables. [SQLSTATE 01000] (Message
14152). The step failed.

I double checked to see which account is the owner of the
agent by:
1) In Enterprise Manager...opening 'Replication Monitor'-
>'Agent'->' Miscellaneous Agents'
2) right-clicking 'distribution clean up: distribution'
3) choosing 'agent properties'
4) checking owner under the general tab

The owner of the agent is 'sa'.

Next, I double checked to see which account runs SQL
Server Agent by:
1) In Enterprise Manager...opening 'Management'
2) right-clicking 'SQL Server Agent'
3) choosing 'properties'
4) under the 'general' tab...I can see the service startup
account

The service startup account is a local windows account.
[Lets refer to the local account as "@LOCAL_ACCT" as to
not use the real name in the forum :)]

How do I log into Query Analyzer using "@LOCAL_ACCT" in
order to test if xp_cmdshell can READ and WRITE to that
directory? I know how to do this using a SQL Server
authenticated login...but not as a windows account...

I look forward to hearing back from you...

Thanks,

John

>-----Original Message-----
>Hi John,
>
>Thank you for you feedback.
>
>Well, since no other processes are using the directory,
the possiblity of
>this factor could be ignored. The 'sa' could be the owner
of the agent
>owner, or the job owner of the clean up job ( you could
unfolder the
>'Replication Monitor'->'Agent'->' Miscellaneous Agents',
right-click the
>'distribution clean up: distribution', choose 'agent
properties' and check
>it in the 'General' tab; Or you could
unfolder 'Management'->'SQL Server
>Agent'->'Job', right-click the job 'distribution clean
up: distribution'
>and in the 'General' tab, checking the owner). However,
as I mentioned
>before, that it will finally run 'xp_cmdshell' to delete
the directory, you
>should check the account which start the SQL Server Agent.
>
>You could get this information by right-click the 'SQL
Server Agent' in the
>'Management' and choose 'Properties', in the 'General'
tab, you will see
>the Start Service Account. Please confirm this account
could run
>'xp_cmdshell' to READ and WRITE the directory instead of
the job owner.
>Also, could you provide the agent 'Distribution Clean Up:
distribution''s
>history by right-click it and choose the 'Agent History'?
>
>Looking forward to your reply! Thanks
>
>Best regards
>
>Baisong Wei
>Microsoft Online Support
>----------------------------------------------------
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>Please reply to newsgroups only. Thanks.
>
>
>.
>

Relevant Pages

  • RE: Domain List could not point to new domain automatically
    ... when you use ADMT to migrate Computer account from one domain to ... it will dispatch a migration agent to the computers. ... Microsoft Online Partner Support ...
    (microsoft.public.windows.server.migration)
  • Re: ADMT (Computer migration)
    ... 2004-02-24 11:02:25 Installing agent on 1 servers ... 2004-02-24 11:02:25 The Active Directory Migration Tool Agent will be ... 2004-02-24 11:02:30 Translating local machine. ... the source account 'migge5' is currently logged on or the profile is in use ...
    (microsoft.public.windows.server.migration)
  • Re: Subscriber Security Settings for Distributor and Publisher log
    ... I cant check the agent properties from here, as the subscriber is in another ... > It is done through SQL Server authentication or NT Authentication. ... using Authentication it authenticates using the account that your SQL Server ...
    (microsoft.public.sqlserver.replication)
  • Re: that OTHER group - UPDATE
    ... other Thunderbird. ...  Newsreaders/Email apps like Thunderbird or Agent allow you to ...  Once you're in your Gmail account, ... Settings and click the Forwarding/POP and IMAP tab. ...
    (alt.sports.baseball.ny-yankees)
  • Re:Access Denied when using ADMT to migrate Computer Accounts
    ... I had already add the Domain Admins to the C drive prior, ... The issue may occur if the user account that you use to run the ADMT tool ... doesn't have the local administrator permission of the Windows XP ... | domain...computer account is copied ok, but the dispatching of the agent ...
    (microsoft.public.windows.server.migration)