Hello all.
Me again. I'm finding some of these replication errors very hard to track
down. With your great guidance I'm working on replicating via the internet. I
think I know what has to be done now, but when configuring the publisher to
create ftp snapshots, the snapshot agent is throwing an error of:
The process could not create file
'D:\snapshots\ftp\DB_Test_DB_Test\20050411145407'.
Cannot create a file when that file already exists.
(Source: (OS); Error number: 183)
I have no idea why this is occuring. The directory is empty when I start,
that numbered directory is created by the snapshot agent fine. Why the heck
won't it continue and generate the snapshots inside the directory? The error
isn't making any sense at all.
Any help would be greatly appreciated.
Very strange. Can you check that you're just using the alternative snapshot
location only - this is recommended but shouldn't cause any problem. Also,
can you delete the directory and rerun the snapshot agent. Actually, it
might be due to an identically named article - I know this isn't possible,
but if you are using owner prefixes to distinguish objects it might be
possible. Perhaps you can enable logging and we'll find out the object name
involved (http://support.microsoft.com/?id=312292).
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Paul your a genius, I would of never thought of that being the problem. It
seems as if it was trying to generate snapshots in both locations, but
failed. I'm finding theres lots of tid bits about SQL 2000 replication that
you have to know because it doesn't all work as you expect sometimes.
Great that you guys are around though. I greatly appreciate your help
throughout. I did replication via handheld devices with msdn's help and this
technology can be awesome once you get a hang of it.
Now lets hook up my subscribers and hope all goes well!
Thanks again and take care.
"Paul Ibison" wrote:
> Very strange. Can you check that you're just using the alternative snapshot
> location only - this is recommended but shouldn't cause any problem. Also,
> can you delete the directory and rerun the snapshot agent. Actually, it
> might be due to an identically named article - I know this isn't possible,
> but if you are using owner prefixes to distinguish objects it might be
> possible. Perhaps you can enable logging and we'll find out the object name
> involved (http://support.microsoft.com/?id=312292).
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Hmm one question I do have. Now that the snapshots are generated, I don't
recall the subscriber configuration ever asking for a FTP login/password.
How does the FTP login info work? Do I have to setup the FTP login
information to match an SQL login?
"Synced" wrote:
[vbcol=seagreen]
> Paul your a genius, I would of never thought of that being the problem. It
> seems as if it was trying to generate snapshots in both locations, but
> failed. I'm finding theres lots of tid bits about SQL 2000 replication that
> you have to know because it doesn't all work as you expect sometimes.
> Great that you guys are around though. I greatly appreciate your help
> throughout. I did replication via handheld devices with msdn's help and this
> technology can be awesome once you get a hang of it.
> Now lets hook up my subscribers and hope all goes well!
> Thanks again and take care.
> "Paul Ibison" wrote:
|||AFAIR in SQL Server 7.0 the ftp login info was set up on the subscriber
side, but not so in SQL Server 2000. Here it is part of the publication
properties. If you have successfully synchronized, this is because the
anonymous FTP has been enabled.
Rgds,
Paul Ibison
|||Hmm looks like I have a dilemma. Some of my subscribers are going to be
behind a firewall. Is there a way to tell the subscription FTP client to use
PASSIVE mode?
I don't think microsoft would have left this out but I can't seem to find
any info.
Thanks again guys!
"Synced" wrote:
[vbcol=seagreen]
> Hmm one question I do have. Now that the snapshots are generated, I don't
> recall the subscriber configuration ever asking for a FTP login/password.
> How does the FTP login info work? Do I have to setup the FTP login
> information to match an SQL login?
> "Synced" wrote:
|||Synced,
what is PASSIVE mode?
If you can't open port 21 then there is another option. Create the snapshot,
get it to the subscriber, then subscribe and select to use an alternative
snapshot location - on the properties of the distribution agent.
Rgds,
Paul Ibison
"Synced" <Synced@.discussions.microsoft.com> wrote in message
news:93709910-3C8E-4148-8BFA-090FE78C219F@.microsoft.com...[vbcol=seagreen]
> Hmm looks like I have a dilemma. Some of my subscribers are going to be
> behind a firewall. Is there a way to tell the subscription FTP client to
> use
> PASSIVE mode?
> I don't think microsoft would have left this out but I can't seem to find
> any info.
> Thanks again guys!
> "Synced" wrote:
|||Hey Paul,
I'm not sure how familiar you are with the FTP protocol, but the FTP
protocol has 2 modes, active and passive. Active is very difficult for
systems behind a firewall because of the flawed design in the FTP protocol.
Although FTP was designed way before firewalls were required for security.
Basically FTP by default runs in active mode. I log into an FTP, when I do a
dir, or GET, my client chooses a random port to transfer data on, tells the
FTP server, the FTP server actually does the connecting to the client. So
port 21 is only really the "control" port, not the data transfer port.
In passive mode, its the other way around. Passive FTP is automatically used
in IE etc I believe because so many people are behind NAT's and firewalls.
Right now my subscriber is behind a firewall so allowing port 21 is not
solving this issue. If I ftp in a FTP client, in default mode (active) I
cannot do a dir, or get command, but if I enable passive, everything works
fine.
My question is. Is there a way to enable passive mode for whatever
mechanism replication uses for a FTP client?
Does replication agent use the command like ftp command? If so the command
line ftp.exe doesn't support passive mode. If it does use ftp.exe, can I
swap ftp.exe with a 3rd party one that supports passive mode.
I really hope we can find a solution for this. Basically when I run my
subscription, it just says connecting to server... and sits there. But when I
FTP in a ftp client with the same info it logs in fine. just can't transfer
any data unless you enable passive mode.
I really hope I'm not totally stuck on this. I can't see this being not
possible since many many servers are behind firewalls these days.
Thanks a ton Paul,
Take care.
"Paul Ibison" wrote:
> Synced,
> what is PASSIVE mode?
> If you can't open port 21 then there is another option. Create the snapshot,
> get it to the subscriber, then subscribe and select to use an alternative
> snapshot location - on the properties of the distribution agent.
> Rgds,
> Paul Ibison
>
> "Synced" <Synced@.discussions.microsoft.com> wrote in message
> news:93709910-3C8E-4148-8BFA-090FE78C219F@.microsoft.com...
>
>
|||Synced,
I'm not going to be able to help much more as this is way, way beyond my
knowledge/experience of FTP. In my case I go through 2 firewalls and I just
asked the network guys to open up port 21 on both of them which worked fine.
Perhaps someone else can contribute here for us....
Rgds,
Paul
"Synced" <Synced@.discussions.microsoft.com> wrote in message
news:732B58F3-73D9-4D38-AC7D-68E527AC2274@.microsoft.com...[vbcol=seagreen]
> Hey Paul,
> I'm not sure how familiar you are with the FTP protocol, but the FTP
> protocol has 2 modes, active and passive. Active is very difficult for
> systems behind a firewall because of the flawed design in the FTP
> protocol.
> Although FTP was designed way before firewalls were required for security.
> Basically FTP by default runs in active mode. I log into an FTP, when I do
> a
> dir, or GET, my client chooses a random port to transfer data on, tells
> the
> FTP server, the FTP server actually does the connecting to the client. So
> port 21 is only really the "control" port, not the data transfer port.
> In passive mode, its the other way around. Passive FTP is automatically
> used
> in IE etc I believe because so many people are behind NAT's and firewalls.
> Right now my subscriber is behind a firewall so allowing port 21 is not
> solving this issue. If I ftp in a FTP client, in default mode (active) I
> cannot do a dir, or get command, but if I enable passive, everything works
> fine.
> My question is. Is there a way to enable passive mode for whatever
> mechanism replication uses for a FTP client?
> Does replication agent use the command like ftp command? If so the command
> line ftp.exe doesn't support passive mode. If it does use ftp.exe, can I
> swap ftp.exe with a 3rd party one that supports passive mode.
> I really hope we can find a solution for this. Basically when I run my
> subscription, it just says connecting to server... and sits there. But
> when I
> FTP in a ftp client with the same info it logs in fine. just can't
> transfer
> any data unless you enable passive mode.
> I really hope I'm not totally stuck on this. I can't see this being not
> possible since many many servers are behind firewalls these days.
> Thanks a ton Paul,
> Take care.
> "Paul Ibison" wrote:
