| Author |
merge Replication across Internet
|
|
| PELEAANIL 2005-09-25, 7:23 am |
| I'm want to setup merge replication ( sql 2000 ) where one sql server would
be installed with a hosting provider & other would be in our office. I'm
able to setup a test setup in my office between 2 servers which are in same
NT domain.
I have queries about how to setting up merge replication over internet. I
request all sql replication expertes to please answer my query.
1. While setting up merge replication is it a must to have point to point
connect i.e do we need to have a leased line connectivity between hosting
provider where we would be hosting sql server & our office ?
2. The server hosted in hosting provider should be made to log in to our NT
office domain or can i keep this server in standalone mode & achieve merge
replication ?
2.My office has internet connectivity via some isp. If leased line
connectivity to hosting provider is not possible then how can i setup merge
replication on internet ? At my server hosted in hosting provider do i need
to setup vpn ( l2tp ) connectivity to my server in office ? Please note that
in my test setup in office both servers were in same NT domain & connected in
a LAN.Idea of vpn connectivity is to extend my office network over internet
to the server hosted in hosting provider. is my direction of thinking right ?
Please share your experiences if some one in this forumn has implmented a
similar setup.
tanks......
| |
| Hilary Cotter 2005-09-25, 9:23 am |
| 1) You need some form of connectivity - whether it is across the internet or
through a dedicated lease line doesn't matter. You might want to use a VPN
for security requirements.
2) You don't need to create a trust relationship between your domain and the
hosting company server/domain. You would use SQL authentication and FTP for
this. Consult this kb for more information.
http://support.microsoft.com/defaul...kb;en-us;321822
2) As long as you can connect to both servers using Enterprise Manager you
will be ok. Note that you will probably want to register both servers using
the NetBIOS names (what is returned via select @@servername and which should
match xp_cmdshell 'hostname'). Use Client Network Utility to build an alias
which will match the Fully Qualified DomainName of the SQL Server i.e.
(SQLServer1.ResourceDomain.Microsoft.com).
Using a VPN is not essential. Microsoft does recommend it for security
reasons. If you are concerned about security (i.e. are a bank or have
sensitive data) use a VPN, if you are not concerned you don't have to use a
VPN. Using a VPN slows down communication, because of this many companies
choose not to use 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
"PELEAANIL" < PELEAANIL@discussion
s.microsoft.com> wrote in message
news:470A0759-D7D8-4275-BDB1- 58F4B4BCC3B2@microso
ft.com...
> I'm want to setup merge replication ( sql 2000 ) where one sql server
would
> be installed with a hosting provider & other would be in our office. I'm
> able to setup a test setup in my office between 2 servers which are in
same
> NT domain.
> I have queries about how to setting up merge replication over internet. I
> request all sql replication expertes to please answer my query.
>
> 1. While setting up merge replication is it a must to have point to point
> connect i.e do we need to have a leased line connectivity between hosting
> provider where we would be hosting sql server & our office ?
>
> 2. The server hosted in hosting provider should be made to log in to our
NT
> office domain or can i keep this server in standalone mode & achieve
merge
> replication ?
>
> 2.My office has internet connectivity via some isp. If leased line
> connectivity to hosting provider is not possible then how can i setup
merge
> replication on internet ? At my server hosted in hosting provider do i
need
> to setup vpn ( l2tp ) connectivity to my server in office ? Please note
that
> in my test setup in office both servers were in same NT domain & connected
in
> a LAN.Idea of vpn connectivity is to extend my office network over
internet
> to the server hosted in hosting provider. is my direction of thinking
right ?
>
> Please share your experiences if some one in this forumn has implmented a
> similar setup.
> tanks......
>
>
| |
| PELEAANIL 2005-09-25, 1:23 pm |
| Many thanks for reply.I suppose my office network has firewall & suppose
hosting provider also has firewall, then for merge replication which ports
would be involved?Based on your inputs will talk to my network team in office
regarding the same.
"Hilary Cotter" wrote:
> 1) You need some form of connectivity - whether it is across the internet or
> through a dedicated lease line doesn't matter. You might want to use a VPN
> for security requirements.
>
> 2) You don't need to create a trust relationship between your domain and the
> hosting company server/domain. You would use SQL authentication and FTP for
> this. Consult this kb for more information.
> http://support.microsoft.com/defaul...kb;en-us;321822
>
> 2) As long as you can connect to both servers using Enterprise Manager you
> will be ok. Note that you will probably want to register both servers using
> the NetBIOS names (what is returned via select @@servername and which should
> match xp_cmdshell 'hostname'). Use Client Network Utility to build an alias
> which will match the Fully Qualified DomainName of the SQL Server i.e.
> (SQLServer1.ResourceDomain.Microsoft.com).
>
> Using a VPN is not essential. Microsoft does recommend it for security
> reasons. If you are concerned about security (i.e. are a bank or have
> sensitive data) use a VPN, if you are not concerned you don't have to use a
> VPN. Using a VPN slows down communication, because of this many companies
> choose not to use 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
> "PELEAANIL" < PELEAANIL@discussion
s.microsoft.com> wrote in message
> news:470A0759-D7D8-4275-BDB1- 58F4B4BCC3B2@microso
ft.com...
> would
> same
>
> NT
> merge
> merge
> need
> that
> in
> internet
> right ?
>
>
>
| |
| Hilary Cotter 2005-09-25, 8:23 pm |
|
--
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
"PELEAANIL" < PELEAANIL@discussion
s.microsoft.com> wrote in message
news:1A422957-611D-45FC-8D3E- A734340ECC27@microso
ft.com...
> Many thanks for reply.I suppose my office network has firewall & suppose
> hosting provider also has firewall, then for merge replication which ports
> would be involved?Based on your inputs will talk to my network team in
office[color=darkred
]
> regarding the same.
>
> "Hilary Cotter" wrote:
>
internet or[color=darkred]
VPN[color=darkred]
the[color=darkred]
for[color=darkred]
you[color=darkred]
using[color=darkred]
should[color=darkred
]
alias[color=darkred]
use a[color=darkred]
companies[color=dark
red]
I'm[color=darkred]
internet. I[color=darkred]
point[color=darkred]
hosting[color=darkre
d]
our[color=darkred]
note[color=darkred]
connected[color=dark
red]
implmented a[color=darkred]
| |
| Hilary Cotter 2005-09-25, 8:23 pm |
| ports 1433 and 21 (for ftp).
--
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
"PELEAANIL" < PELEAANIL@discussion
s.microsoft.com> wrote in message
news:1A422957-611D-45FC-8D3E- A734340ECC27@microso
ft.com...
> Many thanks for reply.I suppose my office network has firewall & suppose
> hosting provider also has firewall, then for merge replication which ports
> would be involved?Based on your inputs will talk to my network team in
office[color=darkred
]
> regarding the same.
>
> "Hilary Cotter" wrote:
>
internet or[color=darkred]
VPN[color=darkred]
the[color=darkred]
for[color=darkred]
you[color=darkred]
using[color=darkred]
should[color=darkred
]
alias[color=darkred]
use a[color=darkred]
companies[color=dark
red]
I'm[color=darkred]
internet. I[color=darkred]
point[color=darkred]
hosting[color=darkre
d]
our[color=darkred]
note[color=darkred]
connected[color=dark
red]
implmented a[color=darkred]
|
|
|
|