Merge replication over internet

Good morning,
I am attempting to set up merge replication between a SQL Server on SBS2003
box (publisher and distributor) and a SQL Server 2000 box (subscriber) in a
different state (hosted, connect via IP addresses).
I can push the publication to the subscriber, but the synch process fails
with error 14010 (I think..not in front of right now).
This is my first attempt at replication...any help is appreciated
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
Kevin,
are you using an IP address - it'll need to be an alias instead. Have a look
at this article to see if you have missed anything out:
http://support.microsoft.com/?id=321822
HTH,
Paul Ibison
|||Kevin,
are you using an IP address - it'll need to be an alias instead. Have a look
at this article to see if you have missed anything out:
http://support.microsoft.com/?id=321822
HTH,
Paul Ibison
|||My bad...I have set up the alias through the Client Network Utility on the
Publisher, using the correct name of the server as the alias name. Did same
at the Subscriber to connect to the Publisher...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23M5rAAfXEHA.3988@.tk2msftngp13.phx.gbl...
> Kevin,
> are you using an IP address - it'll need to be an alias instead. Have a
look
> at this article to see if you have missed anything out:
> http://support.microsoft.com/?id=321822
> HTH,
> Paul Ibison
>
|||My bad...I have set up the alias through the Client Network Utility on the
Publisher, using the correct name of the server as the alias name. Did same
at the Subscriber to connect to the Publisher...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23M5rAAfXEHA.3988@.tk2msftngp13.phx.gbl...
> Kevin,
> are you using an IP address - it'll need to be an alias instead. Have a
look
> at this article to see if you have missed anything out:
> http://support.microsoft.com/?id=321822
> HTH,
> Paul Ibison
>
|||make sure you download the snapshot using FTP and use anonymous pull
subscribers.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:O7uf3GfXEHA.1036@.TK2MSFTNGP10.phx.gbl...
> My bad...I have set up the alias through the Client Network Utility on the
> Publisher, using the correct name of the server as the alias name. Did
same
> at the Subscriber to connect to the Publisher...
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:%23M5rAAfXEHA.3988@.tk2msftngp13.phx.gbl...
> look
>
|||make sure you download the snapshot using FTP and use anonymous pull
subscribers.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:O7uf3GfXEHA.1036@.TK2MSFTNGP10.phx.gbl...
> My bad...I have set up the alias through the Client Network Utility on the
> Publisher, using the correct name of the server as the alias name. Did
same
> at the Subscriber to connect to the Publisher...
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:%23M5rAAfXEHA.3988@.tk2msftngp13.phx.gbl...
> look
>
|||OK...so a push to the subscriber does not work? Is that only for
local/Lan/trusted setups?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:%236%23vp4fXEHA.1292@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> make sure you download the snapshot using FTP and use anonymous pull
> subscribers.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:O7uf3GfXEHA.1036@.TK2MSFTNGP10.phx.gbl...
the[vbcol=seagreen]
> same
a
>
|||OK...so a push to the subscriber does not work? Is that only for
local/Lan/trusted setups?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:%236%23vp4fXEHA.1292@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> make sure you download the snapshot using FTP and use anonymous pull
> subscribers.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:O7uf3GfXEHA.1036@.TK2MSFTNGP10.phx.gbl...
the[vbcol=seagreen]
> same
a
>
|||Not really. You can push or pull within a LAN, locally, or within a trusted
network or across a WAN, Internet, etc.
The decision to use push or pull depends on many factors
1) pull performance is better, but you have no central point of
administration
2) It is a security risk to open the ports necessary to push over the
internet.
3) You can't do a push using FTP.
4) pull is better when your subscribers are occasionally connected, push is
better when they are always connected.
In general when you hear the word internet - think pull.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:OEs0JSgXEHA.1292@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> OK...so a push to the subscriber does not work? Is that only for
> local/Lan/trusted setups?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:%236%23vp4fXEHA.1292@.TK2MSFTNGP11.phx.gbl...
> the
Did[vbcol=seagreen]
DBAs.[vbcol=seagreen]
Have
> a
>