Re: distribution clean up job fail

The Administrator Account or whatever account the distribution agent is
running under in sql 2005, or whatever account SQL Server agent is running
under in SQL 2000 must have read, list files and folders, and delete
permission on the share and underlying files and folders for this to work.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"MLi" <lige888@xxxxxxxxx> wrote in message
news:%23eGLGqXEGHA.3004@xxxxxxxxxxxxxxxxxxxxxxx
>I have created a snapshot replication between ServerA and ServerB, the
>snapshot file location is \\SERVERA\ReplData. Everything runs fine except
>the distribution clean up job fails every 10 minutes. The error message is:
>
> Executed as user: 'ACCOUNT_NAME'. Could not remove directory
> '\\SERVERA\ReplData\unc\ServerA_NorthWind_NorthWind\20060102190012'. 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.
>
> The job owner is the SQL Agent service account, which is a member of
> domain admins.
> No other user is accessing the folder
> '\\SERVERA\ReplData\unc\ServerA_NorthWind_NorthWind\20060102190012'.
> The share permission for \\SERVERA\ReplDATA is: domain admins has full,
> everyone has read permission.
>
> I grant Domain users "Change" permission and run the clean up job, it
> succeed, and the folder 20060102190012 has been deleted.
>
> My question is did I set the share permission correctly? Is this the right
> solution to fix this issue?
> If Domain Users has "Change" permission on the snapshot file folder, will
> this cause security issue?
>
>
>


.

Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... Warren Brunk - MCITP - SQL 2005, ... Add it as a login to the SQL Server ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • Re: User authentication
    ... There are 2 SQL Server 2005 ... 1 SQL Server 2000 installed on another server ... Windows account instead to run backup jobs. ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)
  • Re: Microsoft Search service cannot be administered under the present user error SP3
    ... - Have not modified Administrator account, but i ran the SQL script anyway. ... SQL account is not a local administrator. ... > has this server ever been upgrade from SQL Server 7.0 or is this SQL ...
    (microsoft.public.sqlserver.server)
Loading