November 11, 2009 at 6:07 am
I am really confused by this extract from BoL in regards to Snapshot Agent:
Process account
Enter a Windows account under which the Snapshot Agent runs at the Distributor. The Windows account you specify must:
At minimum be a member of the db_owner fixed database role in the distribution database.
Have write permissions on the snapshot share.
Password and Confirm password
Enter the password for the Windows account.
The reason for my confusion is that my Distributor and Publisher are in seperate domains. As such how can I use a windows account that my Snapshot agent can run under?
November 11, 2009 at 6:54 am
got to ask...
why is your publisher and distributor in different domains. and just out of curiosity is there trust between the domains
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
November 11, 2009 at 8:58 am
unfortunately no trust between domains. In an effort to reduce pressure on the publisher we are running the snapshot on a remote distributor.
November 11, 2009 at 10:02 am
Amazingly I seem to have got so far in getting this to work using an FTP server, this is all locally at the moment. I used a Domain account on the distributor to run the snapshot agent under, and a SQL account to connect to the publisher.
However all afternoon I have been getting a:
Message: 550 /129.11.2.178/C$/Snapshot/ftp: The system cannot find the path specified.
2009-11-11 16:57:28.028 Category:COMMAND
Source: Failed Command
Number:
Message: if @@trancount > 0 rollback tran
2009-11-11 16:57:28.028 Category:AGENT
Source: AGENT
Number:
Message: The process could not connect to FTP site 'D0121' using port 21.
When trying to get my subscriber to pick up from my FTP folder. The agent accounts have full access at that folder level, and the subscription is set to pick up from the FTP folder. The /'s seem a bit odd to me in the error as shouldn't the first be a // ? Not sure where to change that though in the subscription without selecting it as an alternate folder?
Any ideas?
Thanks
November 13, 2009 at 8:51 am
Sorted it - was me not reading the field properly, I was including the root path when I didn't need to.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply