error on sql 2005 regarding transactional replication

[kodaksmile]

Hi all,

I set up transactional replication in a pull scenario. Also enabled xp_cmdshell on both servers. One of the cleanup jobs keeps erroring out with the error below.

The job is the distribution cleanup job:

Could not remove directory '\\servxxx001\repldata\unc\SACxxx001_EXP_xxx_xxx xxx DATA FOR REPORTING\20070911172234\'. Check the security context of xp_cmdshell and close other processes that may be accessing the directory. [SQLSTATE 42000] (Error 20015). The step failed.

Any suggestions?

 

[ptheriault]

Check the permissions on the repldata share. Make sure the account you are using to execute the xp_cmdshell has access to it.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

And that the account which is running the delete command has full control of both the share and NTFS permissions.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com