Re: Failed to Create Directory

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



"Dave B" <DaveB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8B27273C-489F-4A71-9877-22B45865E2B1@xxxxxxxxxxxxxxxx
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?







--
Dave B


.

Relevant Pages

  • Re: xp_cmdshell issue, local system
    ... SQL Server MVP ... > you change startup account ... >> Server and SQL Agent service accounts. ...
    (microsoft.public.sqlserver.security)
  • Re: xp_cmdshell issue, local system
    ... > How is that it worked for one (sql server startup account) but not for ... Server and SQL Agent service accounts. ... SQL Server MVP ... Now when I go and try the same for the agent startup account it ...
    (microsoft.public.sqlserver.security)
  • Re: xp_cmdshell issue, local system
    ... So initially I tried to change the login using EM, ... account to the localsystem for SQL Server and the same for agent which worked ... Now when I go and try the same for the agent startup account it ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot Restart SQL Server Agent
    ... Try to change the start up account for SQL Agent to ... "Local system account" and try starting the service. ... I even stopped the SQL Server and restarted it, ...
    (microsoft.public.sqlserver.server)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)