Failed to Create Directory -- sql server replication

Dave B
8/25/2006 2:01:01 PM

I am creating a dynamic filtered merge replication using FTP, both machines
are SQL 2005(SP1) and are on seperate non-trusted domains within the
company.The anonymous user on the FTP site has full rights and no password,
this is just a POC. I have set up the publisher to use the unc path the the
FTP because of pull subscription. However I keep getting the following error:

Message: The replication agent failed to create the directory
'\\xxcau\holding\ftp\DEVSQL05_DAVETEST_PUB1\20060825163807\'.

Followed by:

Source: mscorlib
Target Site: Void WinIOError(Int32, System.String)
Message: Logon failure: unknown user name or bad password.

I have seen posting regarding the setting up of the IUSR_Machine account on
the publisher, however the FTP site is on the differnt domain from the
publisher, so I would not be able to register the domain\IUSR_Machine user.

Any suggestions?

--

Hilary Cotter
8/25/2006 9:55:22 PM

ensure that the sql server agent or the account your merge agent is running
on has full control rights on \\xxcau\holding

If xxcau is a windows XP machine parked in a workgroup there is an nt
connection limit you might be bumping into. Restart your server service and
try again.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

[quoted text, click to view]

sql server replication : Failed to Create Directory