I have an anynonomous pull merge set and working. But, I create a new
table on the client machine with increment and seed as -1000 and -20.
The table is created fine. But when I execture the first synchrnoize
data from the client, the table is changed to be 1, 2, which is what the
server has. I am using SQL-DMO on the client with the following code:
With myMergeObj
.Distributor = inxRS.Globals.gServer
.DistributorLogin = "inxsql"
.DistributorPassword = "inxsql4u"
.DistributorSecurityMode = SECURITY_TYPE.DB_AUTHENTICATION
.DistributorNetwork = NETWORK_TYPE.TCPIP_SOCKETS
.DistributorAddress = inxRS.Globals.gServerIP
.Publisher = inxRS.Globals.gServer
.PublisherDatabase = in_comp
.Publication = Trim(in_comp) & "RS"
.PublisherLogin = "inxsql"
.PublisherPassword = "inxsql4u"
.PublisherSecurityMode = SECURITY_TYPE.DB_AUTHENTICATION
.PublisherNetwork = NETWORK_TYPE.TCPIP_SOCKETS
.PublisherAddress = inxRS.Globals.gServerIP
.Subscriber = Trim(Environment.MachineName)
.SubscriberDatabase = in_comp
.SubscriberSecurityMode = SECURITY_TYPE.NT_AUTHENTICATION
.SubscriptionType = SUBSCRIPTION_TYPE.ANONYMOUS
.SubscriptionName = Trim(in_comp) & "RS"
.HostName = Trim(inxRS.Globals.gLogin)
.ExchangeType = EXCHANGE_TYPE.BIDIRECTIONAL
.ReinitializeSubscription(false)
End With
myMergeObj.Initialize()
myMergeObj.Run()
myMergeObj.Terminate()
I can't tell if it is a problem in the pull or in how the publication
was/is setup.
Thanks.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
I removed the reinit statement and I still have the same problem.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
|||FIXED IT.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
Showing posts with label anynonomous. Show all posts
Showing posts with label anynonomous. Show all posts
Monday, March 12, 2012
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 ***
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 ***
pull subscription
I cannot get a pull subscription to work. I have created my publication
to allow anynonomous. The client is a registered subscriber. On the
subscriber I created the pull subscription always specifying the SQL
server authentication and entering the login/password.
I have enabled loggin, but I can't find where it says this is the
problem.
The error is:
The process could not deliver the snapshot to the subscriber. The step
failed.
I sure would like more information. I am leaning towards a security
issue, but the SQL authentication login and password are also setup on
the server as a user name/password with admin rights.
THe server is Win2000 running SQL 2000. Client is XP Pro running MSDE.
THanks.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
On your publisher connect to your publisher in EM, then go to tools,
replication, configure distributor, publishers, subscribers, click on the
subscriber tab, locate your subscriber, click on the browse button the right
of your subscriber, and in the SQL login enter the sa account and password
of the Publisher. Restart your pull agent.
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:uA7gFbUtFHA.2912@.TK2MSFTNGP09.phx.gbl...
> I cannot get a pull subscription to work. I have created my publication
> to allow anynonomous. The client is a registered subscriber. On the
> subscriber I created the pull subscription always specifying the SQL
> server authentication and entering the login/password.
> I have enabled loggin, but I can't find where it says this is the
> problem.
> The error is:
> The process could not deliver the snapshot to the subscriber. The step
> failed.
> I sure would like more information. I am leaning towards a security
> issue, but the SQL authentication login and password are also setup on
> the server as a user name/password with admin rights.
> THe server is Win2000 running SQL 2000. Client is XP Pro running MSDE.
> THanks.
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
to allow anynonomous. The client is a registered subscriber. On the
subscriber I created the pull subscription always specifying the SQL
server authentication and entering the login/password.
I have enabled loggin, but I can't find where it says this is the
problem.
The error is:
The process could not deliver the snapshot to the subscriber. The step
failed.
I sure would like more information. I am leaning towards a security
issue, but the SQL authentication login and password are also setup on
the server as a user name/password with admin rights.
THe server is Win2000 running SQL 2000. Client is XP Pro running MSDE.
THanks.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
On your publisher connect to your publisher in EM, then go to tools,
replication, configure distributor, publishers, subscribers, click on the
subscriber tab, locate your subscriber, click on the browse button the right
of your subscriber, and in the SQL login enter the sa account and password
of the Publisher. Restart your pull agent.
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:uA7gFbUtFHA.2912@.TK2MSFTNGP09.phx.gbl...
> I cannot get a pull subscription to work. I have created my publication
> to allow anynonomous. The client is a registered subscriber. On the
> subscriber I created the pull subscription always specifying the SQL
> server authentication and entering the login/password.
> I have enabled loggin, but I can't find where it says this is the
> problem.
> The error is:
> The process could not deliver the snapshot to the subscriber. The step
> failed.
> I sure would like more information. I am leaning towards a security
> issue, but the SQL authentication login and password are also setup on
> the server as a user name/password with admin rights.
> THe server is Win2000 running SQL 2000. Client is XP Pro running MSDE.
> THanks.
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
Subscribe to:
Posts (Atom)