Hi;
Before I have done probes with a sql server (role publicator and distributor
in the same machine whit transactional replication)and a pull anonymus
suscription over internet (thought a router-NAT and Firewall).
In suscriber I used an alias for the publisher, and I obtained that
replciation system worked well.
Now, I have a configuration replication system and one publication (permit
anonymus suscriptions)
1) Publicator in one Sql Server with a publication and correct permiss.
2) Distributor in other Sql Server.
Both server communicate well and the replicaton work without problem
(aconting agents are well).
But, I have problems with pull anonymus suscribers configuration over
Internet.
Only Distribuitor Server is accessible througt Internet (router is TCP
listen port).
1) Suscriber should can access both servers over Internet (Publicator and
Distribuitor) ?
or only Distribuitor server ?
2) If only Distribuitor should can access from Suscriber, how I configure
Suscription, because publication are not visibles for this.
I hope that help me for this configuration.
Thanks.
Mario Barro
Another information computer Suscriber is:
Windows XP Prof.
Thanks.
"Mario Barro" <newsss@.QUITAMEya.com> escribi en el mensaje
news:uGVfQvybEHA.2468@.TK2MSFTNGP09.phx.gbl...
> Hi;
> Before I have done probes with a sql server (role publicator and
distributor
> in the same machine whit transactional replication)and a pull anonymus
> suscription over internet (thought a router-NAT and Firewall).
> In suscriber I used an alias for the publisher, and I obtained that
> replciation system worked well.
> Now, I have a configuration replication system and one publication (permit
> anonymus suscriptions)
> 1) Publicator in one Sql Server with a publication and correct permiss.
> 2) Distributor in other Sql Server.
> Both server communicate well and the replicaton work without problem
> (aconting agents are well).
> But, I have problems with pull anonymus suscribers configuration over
> Internet.
> Only Distribuitor Server is accessible througt Internet (router is TCP
> listen port).
>
> 1) Suscriber should can access both servers over Internet (Publicator and
> Distribuitor) ?
> or only Distribuitor server ?
> 2) If only Distribuitor should can access from Suscriber, how I configure
> Suscription, because publication are not visibles for this.
>
> I hope that help me for this configuration.
>
> Thanks.
> Mario Barro
>
Showing posts with label pull. Show all posts
Showing posts with label pull. Show all posts
Wednesday, March 7, 2012
Anonymous Subscriptions using SQLDMO
Hi guys - I have been able to successfully create pull merge
subscriptions in SQLDMO. Now I am trying to do anonymous subscriptions and I
am having a little difficulty.
I made sure to allow anonymous subscriptions at the publication. I
created an object of type MergePullSubscription2 and called it "sub" and set
the properties as follows:
sub.SubscriptionType = .SQLDMOSubscription_Anonymous;
sub.SubscriberType = .SQLDMOMergeSubscriber_Anonymous;
(and set all the other properties appropriately) and then added it to
the MergePullSubscriptions collection.
All of that works fine. But then I try to enable it at the publisher by
using the method EnableMergeSubscription (I make sure to use the constant
SQLDMOMergeSubscriber_Anonymous for the SubscriberType argument) and that
gives me the following error:
"[Microsoft][ODBC SQL Server Driver][SQL Server]The remote server is not
defined as a subscription server."
(this is strange because I can create other subscriptions that are not
anonymous)
Is this step (EnableMergeSubscription ) necessary? It seems to be
because if I try to sync, it fails.
It seems like anonymous subs should be pretty straightforward, but I
must be missing something fundamental.
Any help will be much appreciated.
Maer
Hello,
I suggest that you refer to the information on the following web site:
MergePullSubscription Object
http://msdn.microsoft.com/library/de...us/sqldmo/dmor
ef_ob_m_0egk.asp
To create a merge anonymous subscription at the Subscriber:
1.Create a new MergePullSubscription object.
2.Set the Publisher property to the name of an existing Publisher.
3.Set the PublicationDB property to the name of the database (at the
Publisher) where the publication is located.
4.Set the Publication property to the name of the publication to which to
subscribe.
5.Set the SubscriberType property to SQLDMOMergeSubscriber_Anonymous.
6.Set the SecurityMode property of the DistributorSecurity object property
as appropriate.
7.If the SecurityMode property of the DistributorSecurity object property
is set to SQLDMOReplSecurity_Normal, set the StandardLogin and
StandardPassword properties of the DistributorSecurity object property.
8.Set the SecurityMode property of the PublisherSecurity object property
as appropriate.
9.If the SecurityMode property of the PublisherSecurity object property is
set to SQLDMOReplSecurity_Normal, set the StandardLogin and
StandardPassword properties of the PublisherSecurity object property.
10.Note that the Name property defaults to
publisher:publication_database:publication.
11.Add the MergePullSubscription object to the MergePullSubscriptions
collection of a connected ReplicationDatabase object at the Subscriber.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
subscriptions in SQLDMO. Now I am trying to do anonymous subscriptions and I
am having a little difficulty.
I made sure to allow anonymous subscriptions at the publication. I
created an object of type MergePullSubscription2 and called it "sub" and set
the properties as follows:
sub.SubscriptionType = .SQLDMOSubscription_Anonymous;
sub.SubscriberType = .SQLDMOMergeSubscriber_Anonymous;
(and set all the other properties appropriately) and then added it to
the MergePullSubscriptions collection.
All of that works fine. But then I try to enable it at the publisher by
using the method EnableMergeSubscription (I make sure to use the constant
SQLDMOMergeSubscriber_Anonymous for the SubscriberType argument) and that
gives me the following error:
"[Microsoft][ODBC SQL Server Driver][SQL Server]The remote server is not
defined as a subscription server."
(this is strange because I can create other subscriptions that are not
anonymous)
Is this step (EnableMergeSubscription ) necessary? It seems to be
because if I try to sync, it fails.
It seems like anonymous subs should be pretty straightforward, but I
must be missing something fundamental.
Any help will be much appreciated.
Maer
Hello,
I suggest that you refer to the information on the following web site:
MergePullSubscription Object
http://msdn.microsoft.com/library/de...us/sqldmo/dmor
ef_ob_m_0egk.asp
To create a merge anonymous subscription at the Subscriber:
1.Create a new MergePullSubscription object.
2.Set the Publisher property to the name of an existing Publisher.
3.Set the PublicationDB property to the name of the database (at the
Publisher) where the publication is located.
4.Set the Publication property to the name of the publication to which to
subscribe.
5.Set the SubscriberType property to SQLDMOMergeSubscriber_Anonymous.
6.Set the SecurityMode property of the DistributorSecurity object property
as appropriate.
7.If the SecurityMode property of the DistributorSecurity object property
is set to SQLDMOReplSecurity_Normal, set the StandardLogin and
StandardPassword properties of the DistributorSecurity object property.
8.Set the SecurityMode property of the PublisherSecurity object property
as appropriate.
9.If the SecurityMode property of the PublisherSecurity object property is
set to SQLDMOReplSecurity_Normal, set the StandardLogin and
StandardPassword properties of the PublisherSecurity object property.
10.Note that the Name property defaults to
publisher:publication_database:publication.
11.Add the MergePullSubscription object to the MergePullSubscriptions
collection of a connected ReplicationDatabase object at the Subscriber.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
Anonymous Pull using FTP - still insists on using original UNC for file share
I've been trying to set up an anonymous pull subscription for merge
replication - SQL 2000 on both sides, post SP3 & same on both machines.
However, when I set up the replication and try to do the initial sync, the
subscription insists on trying to use the original UNC path where I stored the
files from the publisher. Copying the files locally doesn't seem to help as
it still tries to access the UNC. Same with FTP - I set up the site &
specified to use it, but it still tries to access the UNC that way. I
verified that it can access the files via FTP and even copied the files
locally to specify a local path.
I tried reading through the BOL, but didn't come up with much to guide me on
what to try next to get it to read the local files. Any suggestions? This is
the only subscriber I'll have, but it's not on the domain and in our DMZ.
Thanks for any ideas you may have.
-Pete Schott
the connection information on how the subscriber connects with the publisher
to pull the subscription is stored on the publisher.
Do a sp_helpmergepublication 'PublicationName' in your publication database
to verify the publication is 1) enabled for the internet 2) has an alternate
snapshot folder that maps to the root or a virtual directory on your ftp
server, 30 has an ftp address
I take it when you created your pull subscription you chose to download your
files using ftp?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Peter A. Schott" <pschott@.no.spamm.hear.drivefinancial.com> wrote in
message news:1qrpc01577kh0g5vsfcvl7r00ioc4d6scg@.4ax.com...
> I've been trying to set up an anonymous pull subscription for merge
> replication - SQL 2000 on both sides, post SP3 & same on both machines.
> However, when I set up the replication and try to do the initial sync, the
> subscription insists on trying to use the original UNC path where I stored
the
> files from the publisher. Copying the files locally doesn't seem to help
as
> it still tries to access the UNC. Same with FTP - I set up the site &
> specified to use it, but it still tries to access the UNC that way. I
> verified that it can access the files via FTP and even copied the files
> locally to specify a local path.
> I tried reading through the BOL, but didn't come up with much to guide me
on
> what to try next to get it to read the local files. Any suggestions?
This is
> the only subscriber I'll have, but it's not on the domain and in our DMZ.
> Thanks for any ideas you may have.
> -Pete Schott
|||Well, I did that - it's enabled for Internet, has an alternate snapshot
folder, and the folder maps to the root of the virtual/ftp directory. It's
able to pull several of the files, but then dies trying to get to the full UNC
path.
It does the same thing if I specify to use an alternate/local path instead. I
can't seem to get away from that UNC. at all.
Any ideas? Has anyone got some steps that work all of the time to apply an
initial snapshot anonymously over FTP?
TIA,
-pete
"Hilary Cotter" <hilaryk@.att.net> wrote:
> the connection information on how the subscriber connects with the publisher
> to pull the subscription is stored on the publisher.
> Do a sp_helpmergepublication 'PublicationName' in your publication database
> to verify the publication is 1) enabled for the internet 2) has an alternate
> snapshot folder that maps to the root or a virtual directory on your ftp
> server, 30 has an ftp address
> I take it when you created your pull subscription you chose to download your
> files using ftp?
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Peter A. Schott" <pschott@.no.spamm.hear.drivefinancial.com> wrote in
> message news:1qrpc01577kh0g5vsfcvl7r00ioc4d6scg@.4ax.com...
> the
> as
> on
> This is
>
replication - SQL 2000 on both sides, post SP3 & same on both machines.
However, when I set up the replication and try to do the initial sync, the
subscription insists on trying to use the original UNC path where I stored the
files from the publisher. Copying the files locally doesn't seem to help as
it still tries to access the UNC. Same with FTP - I set up the site &
specified to use it, but it still tries to access the UNC that way. I
verified that it can access the files via FTP and even copied the files
locally to specify a local path.
I tried reading through the BOL, but didn't come up with much to guide me on
what to try next to get it to read the local files. Any suggestions? This is
the only subscriber I'll have, but it's not on the domain and in our DMZ.
Thanks for any ideas you may have.
-Pete Schott
the connection information on how the subscriber connects with the publisher
to pull the subscription is stored on the publisher.
Do a sp_helpmergepublication 'PublicationName' in your publication database
to verify the publication is 1) enabled for the internet 2) has an alternate
snapshot folder that maps to the root or a virtual directory on your ftp
server, 30 has an ftp address
I take it when you created your pull subscription you chose to download your
files using ftp?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Peter A. Schott" <pschott@.no.spamm.hear.drivefinancial.com> wrote in
message news:1qrpc01577kh0g5vsfcvl7r00ioc4d6scg@.4ax.com...
> I've been trying to set up an anonymous pull subscription for merge
> replication - SQL 2000 on both sides, post SP3 & same on both machines.
> However, when I set up the replication and try to do the initial sync, the
> subscription insists on trying to use the original UNC path where I stored
the
> files from the publisher. Copying the files locally doesn't seem to help
as
> it still tries to access the UNC. Same with FTP - I set up the site &
> specified to use it, but it still tries to access the UNC that way. I
> verified that it can access the files via FTP and even copied the files
> locally to specify a local path.
> I tried reading through the BOL, but didn't come up with much to guide me
on
> what to try next to get it to read the local files. Any suggestions?
This is
> the only subscriber I'll have, but it's not on the domain and in our DMZ.
> Thanks for any ideas you may have.
> -Pete Schott
|||Well, I did that - it's enabled for Internet, has an alternate snapshot
folder, and the folder maps to the root of the virtual/ftp directory. It's
able to pull several of the files, but then dies trying to get to the full UNC
path.
It does the same thing if I specify to use an alternate/local path instead. I
can't seem to get away from that UNC. at all.
Any ideas? Has anyone got some steps that work all of the time to apply an
initial snapshot anonymously over FTP?
TIA,
-pete
"Hilary Cotter" <hilaryk@.att.net> wrote:
> the connection information on how the subscriber connects with the publisher
> to pull the subscription is stored on the publisher.
> Do a sp_helpmergepublication 'PublicationName' in your publication database
> to verify the publication is 1) enabled for the internet 2) has an alternate
> snapshot folder that maps to the root or a virtual directory on your ftp
> server, 30 has an ftp address
> I take it when you created your pull subscription you chose to download your
> files using ftp?
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Peter A. Schott" <pschott@.no.spamm.hear.drivefinancial.com> wrote in
> message news:1qrpc01577kh0g5vsfcvl7r00ioc4d6scg@.4ax.com...
> the
> as
> on
> This is
>
anonymous pull replication problem - Logon failure: unknown user name or bad password.
I have setup a replication sandbox with the following:
server: SQL-Server 2k
workstation: MSDE 2000 (A)
I have setup a replication database on my server and configured it for
anonymous pull subscriptions. I am running this inside my LAN.
I run the following code in an Access 2000 module:
With SQLMerge
.Publisher = "SERVER"
.PublisherAddress = "SERVER"
.PublisherSecurityMode = DB_AUTHENTICATION
.PublisherLogin = "sa"
.PublisherPassword = "nnnn"
.PublisherDatabase = "mydb"
.Publication = "publ_mydb"
.PublisherNetwork = TCPIP_SOCKETS
.Subscriber = "HOME\myapp"
.SubscriberSecurityMode = DB_AUTHENTICATION
.SubscriberLogin = "sa"
.SubscriberPassword = "nnnn"
.SubscriptionType = PULL
.SubscriptionType = ANONYMOUS
.ExchangeType = BIDIRECTIONAL
.FileTransferType = FILETRANSFERUNC
.AddSubscription CREATE_DATABASE, NONE
.Initialize
.Run
.Terminate
End With
The sub runs up to the ".run" command where the logon failure occurs.
I have cut/pasted the login information into QueryAnalyser and am able to
log into the local Server.
I have noticed that the mdf & ldf files are transfered to the workstation
and the database is visible after running this code (without system tables
only).
I have to manually remove the 'mydb' database from EM before trying again.
Is this a security issue? What steps can I take to troubleshoot this?
Thanks very much.
You have to also specify DistrutionNetwork, DistributorLogin,
DistributorPassword and Distributor
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
"astro" <astro@.bcmn.com> wrote in message
news:updsbFFGFHA.2824@.tk2msftngp13.phx.gbl...
> I have setup a replication sandbox with the following:
> server: SQL-Server 2k
> workstation: MSDE 2000 (A)
> I have setup a replication database on my server and configured it for
> anonymous pull subscriptions. I am running this inside my LAN.
> I run the following code in an Access 2000 module:
> With SQLMerge
> .Publisher = "SERVER"
> .PublisherAddress = "SERVER"
> .PublisherSecurityMode = DB_AUTHENTICATION
> .PublisherLogin = "sa"
> .PublisherPassword = "nnnn"
> .PublisherDatabase = "mydb"
> .Publication = "publ_mydb"
> .PublisherNetwork = TCPIP_SOCKETS
> .Subscriber = "HOME\myapp"
> .SubscriberSecurityMode = DB_AUTHENTICATION
> .SubscriberLogin = "sa"
> .SubscriberPassword = "nnnn"
> .SubscriptionType = PULL
> .SubscriptionType = ANONYMOUS
> .ExchangeType = BIDIRECTIONAL
> .FileTransferType = FILETRANSFERUNC
> .AddSubscription CREATE_DATABASE, NONE
> .Initialize
> .Run
> .Terminate
> End With
>
> The sub runs up to the ".run" command where the logon failure occurs.
> I have cut/pasted the login information into QueryAnalyser and am able to
> log into the local Server.
> I have noticed that the mdf & ldf files are transfered to the workstation
> and the database is visible after running this code (without system tables
> only).
> I have to manually remove the 'mydb' database from EM before trying again.
> Is this a security issue? What steps can I take to troubleshoot this?
> Thanks very much.
>
|||oops!
Thanks Hilary
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ertlFqOGFHA.936@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> You have to also specify DistrutionNetwork, DistributorLogin,
> DistributorPassword and Distributor
> --
> 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
> "astro" <astro@.bcmn.com> wrote in message
> news:updsbFFGFHA.2824@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
workstation[vbcol=seagreen]
tables[vbcol=seagreen]
again.
>
server: SQL-Server 2k
workstation: MSDE 2000 (A)
I have setup a replication database on my server and configured it for
anonymous pull subscriptions. I am running this inside my LAN.
I run the following code in an Access 2000 module:
With SQLMerge
.Publisher = "SERVER"
.PublisherAddress = "SERVER"
.PublisherSecurityMode = DB_AUTHENTICATION
.PublisherLogin = "sa"
.PublisherPassword = "nnnn"
.PublisherDatabase = "mydb"
.Publication = "publ_mydb"
.PublisherNetwork = TCPIP_SOCKETS
.Subscriber = "HOME\myapp"
.SubscriberSecurityMode = DB_AUTHENTICATION
.SubscriberLogin = "sa"
.SubscriberPassword = "nnnn"
.SubscriptionType = PULL
.SubscriptionType = ANONYMOUS
.ExchangeType = BIDIRECTIONAL
.FileTransferType = FILETRANSFERUNC
.AddSubscription CREATE_DATABASE, NONE
.Initialize
.Run
.Terminate
End With
The sub runs up to the ".run" command where the logon failure occurs.
I have cut/pasted the login information into QueryAnalyser and am able to
log into the local Server.
I have noticed that the mdf & ldf files are transfered to the workstation
and the database is visible after running this code (without system tables
only).
I have to manually remove the 'mydb' database from EM before trying again.
Is this a security issue? What steps can I take to troubleshoot this?
Thanks very much.
You have to also specify DistrutionNetwork, DistributorLogin,
DistributorPassword and Distributor
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
"astro" <astro@.bcmn.com> wrote in message
news:updsbFFGFHA.2824@.tk2msftngp13.phx.gbl...
> I have setup a replication sandbox with the following:
> server: SQL-Server 2k
> workstation: MSDE 2000 (A)
> I have setup a replication database on my server and configured it for
> anonymous pull subscriptions. I am running this inside my LAN.
> I run the following code in an Access 2000 module:
> With SQLMerge
> .Publisher = "SERVER"
> .PublisherAddress = "SERVER"
> .PublisherSecurityMode = DB_AUTHENTICATION
> .PublisherLogin = "sa"
> .PublisherPassword = "nnnn"
> .PublisherDatabase = "mydb"
> .Publication = "publ_mydb"
> .PublisherNetwork = TCPIP_SOCKETS
> .Subscriber = "HOME\myapp"
> .SubscriberSecurityMode = DB_AUTHENTICATION
> .SubscriberLogin = "sa"
> .SubscriberPassword = "nnnn"
> .SubscriptionType = PULL
> .SubscriptionType = ANONYMOUS
> .ExchangeType = BIDIRECTIONAL
> .FileTransferType = FILETRANSFERUNC
> .AddSubscription CREATE_DATABASE, NONE
> .Initialize
> .Run
> .Terminate
> End With
>
> The sub runs up to the ".run" command where the logon failure occurs.
> I have cut/pasted the login information into QueryAnalyser and am able to
> log into the local Server.
> I have noticed that the mdf & ldf files are transfered to the workstation
> and the database is visible after running this code (without system tables
> only).
> I have to manually remove the 'mydb' database from EM before trying again.
> Is this a security issue? What steps can I take to troubleshoot this?
> Thanks very much.
>
|||oops!
Thanks Hilary
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ertlFqOGFHA.936@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> You have to also specify DistrutionNetwork, DistributorLogin,
> DistributorPassword and Distributor
> --
> 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
> "astro" <astro@.bcmn.com> wrote in message
> news:updsbFFGFHA.2824@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
workstation[vbcol=seagreen]
tables[vbcol=seagreen]
again.
>
Subscribe to:
Posts (Atom)