pull subscription - anynonomous - error HELP

I can't get an anynonmous pull subscription to work. Server is Windows
2000 with SQL Server 2000, client is XP Pro with MSDE 2000.
Setup replication on the server using the wizard:
Snapshot folder in default location
merge one database
don't select any subscribers (my client isn't listed)
Create publication using wizard
Merge
select one table
allow anonymous is marked
After the publication is created, go into the properties of the
publication:
Change the snapshot location to c:\inetpub\ftproot
set the FTP user/login (this login has admin rights)
Run the snapshot agent and the snapshot created successfully.
Now, on the client. the database tables exist, but there is no data.
Select Pull-Subscription to laptop / Pull New Subscription
Specify publication info
Connect using SQL Server authentication, enter login/password (has admin
and SA rights)
agent - use SQL server, same login/password
select database
Yes, initialize the schema and data
download the snapshot using FTP
on demand only
On the client, goto pull subscription under database in EM,
select start synchrnizing.
Server and Client receive error:
The schema script "\\iis-sql\C$\program file\microsoft sql
server\mssql\reldata\unc\iis-sql_msilex_msilex\20051215081206\ARCustomer
_1.sch could not be propaged to the subscriber.
Why do I get this message. I told it to use FTP so why/what is trying to
use the default repl directory.
I need to get this working like this, and then I will work on SQLDMO.
Thanks in advance.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
Did you configure your pull subscription to download the snapshot using ftp?
It doesn't look like it.
Hilary Cotter
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
"Darin" <darin_nospam@.nospamever> wrote in message
news:%23vkgNpYAGHA.3268@.TK2MSFTNGP10.phx.gbl...
>I can't get an anynonmous pull subscription to work. Server is Windows
> 2000 with SQL Server 2000, client is XP Pro with MSDE 2000.
> Setup replication on the server using the wizard:
> Snapshot folder in default location
> merge one database
> don't select any subscribers (my client isn't listed)
> Create publication using wizard
> Merge
> select one table
> allow anonymous is marked
> After the publication is created, go into the properties of the
> publication:
> Change the snapshot location to c:\inetpub\ftproot
> set the FTP user/login (this login has admin rights)
> Run the snapshot agent and the snapshot created successfully.
> Now, on the client. the database tables exist, but there is no data.
> Select Pull-Subscription to laptop / Pull New Subscription
> Specify publication info
> Connect using SQL Server authentication, enter login/password (has admin
> and SA rights)
> agent - use SQL server, same login/password
> select database
> Yes, initialize the schema and data
> download the snapshot using FTP
> on demand only
> On the client, goto pull subscription under database in EM,
> select start synchrnizing.
> Server and Client receive error:
> The schema script "\\iis-sql\C$\program file\microsoft sql
> server\mssql\reldata\unc\iis-sql_msilex_msilex\20051215081206\ARCustomer
> _1.sch could not be propaged to the subscriber.
> Why do I get this message. I told it to use FTP so why/what is trying to
> use the default repl directory.
> I need to get this working like this, and then I will work on SQLDMO.
> Thanks in advance.
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
|||yes, I did. But, even if I re-do everything to NOT use FTP I get the
exact same error.
Did my steps on the wizards seem correct? Did I miss something that has
to be done outside the wizards?
Darin
*** Sent via Developersdex http://www.codecomments.com ***
|||I got it to work FINALLY.
I am not using FTP (I didn't want to anyway, just thought I would try).
The problem was the client server agent account was set to use local
system. I changed that to the same login/password as everything else
(had to create a new user and give admin rights to) and it successfully
replicated.
Now to work on getting it to work from SQLDMO.
Darin
*** Sent via Developersdex http://www.codecomments.com ***