Merge - Pull Snapshot Error

I'm struggling with this error with one of my subscribers. Both the
publisher and subscriber have the services running under the same account &
password. My subscribers use a dial-up connection. To help
troubleshoot, I had the subscriber get connected to the publisher via RAS
and had them run a directory listing on the snapshot location. They
received an error: Logon failure: unknown user name or bad password.
The RAS user account has full access to the snapshot location. This is the
first subscriber out of 15 that I'm experiencing this problem with. The
difference between this one and the other 14 is that this subscriber is
running a full version of SQL Server where as the rest are running MSDE.
The process could not deliver the snapshot to the Subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
The process could not bulk copy into table '"dbo"."sysmergesubsetfilters"'.
(Source: cookieland (Agent); Error number: 20037)
Unable to open BCP host data-file
(Source: ODBC SQL Server Driver (ODBC); Error number: 0)
This is not a replication problem. It is a problem relating to network connectivity or RAS.
Unfortunately my NT/RAS/dialup skills aren't good enough to help you. I suggest you open a ticket with PSS for Win2k networking, or post this question in one of the networking newsgroups.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Tina Smith" wrote:

> I'm struggling with this error with one of my subscribers. Both the
> publisher and subscriber have the services running under the same account &
> password. My subscribers use a dial-up connection. To help
> troubleshoot, I had the subscriber get connected to the publisher via RAS
> and had them run a directory listing on the snapshot location. They
> received an error: Logon failure: unknown user name or bad password.
> The RAS user account has full access to the snapshot location. This is the
> first subscriber out of 15 that I'm experiencing this problem with. The
> difference between this one and the other 14 is that this subscriber is
> running a full version of SQL Server where as the rest are running MSDE.
> The process could not deliver the snapshot to the Subscriber.
> (Source: Merge Replication Provider (Agent); Error number: -2147201001)
> ----
> The process could not bulk copy into table '"dbo"."sysmergesubsetfilters"'.
> (Source: cookieland (Agent); Error number: 20037)
> ----
> Unable to open BCP host data-file
> (Source: ODBC SQL Server Driver (ODBC); Error number: 0)
>
>
|||Thanks Hilary. I have since learned the credentials are cached in XP and
used when you try to access any
resources in the remote network. The same feature is not present pre XP.
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:8BE474D2-F7A1-414E-9B35-5DD6239B8833@.microsoft.com...
> This is not a replication problem. It is a problem relating to network
connectivity or RAS.
> Unfortunately my NT/RAS/dialup skills aren't good enough to help you. I
suggest you open a ticket with PSS for Win2k networking, or post this
question in one of the networking newsgroups.[vbcol=seagreen]
> --
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
>
> "Tina Smith" wrote:
account &[vbcol=seagreen]
RAS[vbcol=seagreen]
the[vbcol=seagreen]
The
> ----
--[vbcol=seagreen]
'"dbo"."sysmergesubsetfilters"'.
> ----
--[vbcol=seagreen]