Friday, March 30, 2012

replication thru vpn

Hi,
Please help, I am new to replication.
I have setup a vpn connection from one computer to another.
e.g. Computer X and computer Y. Both are in different area of the city.
Both computers have mssql 2000. The source database is in computer X.
I like to replicate the data in computer X to computer Y. In computer Y I
can see the X's mssql db. It is shown us 192.168.0.2 in EM.
which is the ip address use in the VPN for computer X. I cannot create the
replication because the computer name is shown as an ip address.
Is there a way to change it to the real computer name?
Can someone please point me to any articles or tutorials that may help me to
set up replication thru VPN or thru the Internet?
Thank You.
Sam
You could try making use of the HOSTS file on the servers to map IP and the
server name. Then try to register SQL servers from enterprise manager
- Sid
"sam" wrote:

> Hi,
> Please help, I am new to replication.
> I have setup a vpn connection from one computer to another.
> e.g. Computer X and computer Y. Both are in different area of the city.
> Both computers have mssql 2000. The source database is in computer X.
> I like to replicate the data in computer X to computer Y. In computer Y I
> can see the X's mssql db. It is shown us 192.168.0.2 in EM.
> which is the ip address use in the VPN for computer X. I cannot create the
> replication because the computer name is shown as an ip address.
> Is there a way to change it to the real computer name?
> Can someone please point me to any articles or tutorials that may help me to
> set up replication thru VPN or thru the Internet?
> Thank You.
> Sam
>
>
>
|||sam wrote:
> Both computers have mssql 2000. The source database is in computer X.
> I like to replicate the data in computer X to computer Y. In computer Y I
> can see the X's mssql db. It is shown us 192.168.0.2 in EM.
> which is the ip address use in the VPN for computer X. I cannot create the
> replication because the computer name is shown as an ip address.
> Is there a way to change it to the real computer name?
Use the Client Network Utility to give that IP an alias.
|||Thanks.
"Ryan Walberg [MCSD]" <generalpf@.nospam.yahoo.reallynospam.com> wrote in
message news:OyovrA9KFHA.2252@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> sam wrote:
I[vbcol=seagreen]
the
> Use the Client Network Utility to give that IP an alias.

No comments:

Post a Comment