Replicate SQL2K through VPN - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Replicate SQL2K through VPN

Author

Topic

nthphuong
Starting Member

5 Posts

Posted - 2003-08-07 : 06:54:50

Hi all,

How to replicate 2 database SQL2K through VPN. 2 server have diferrent subnet

The publication is: 172.16.66.60
The subcription is : 172.16.65.60

I do step by step as below:

1. Add server 172.16.65.60 as remote server
2. Config 172.16.66.60 as Distribution
3. Create new publication on 172.16.66.60
4. Push Subcription into 172.16.65.60

After all, there is error "The subscription to publication 'pubs_table' is invalid"

What's wrong, I know my problem has been answered many times but can not pass it

Please help me more detail

Thanks for any help
Hieu Phuong

shsmonteiro
Constraint Violating Yak Guru

290 Posts

Posted - 2003-08-10 : 21:49:19

Hmmm, that rare. Try to remove the replication pieces using the procedure sp_removedbreplication in the subscribing DB. Also, check that you can connect from both server to each other. Also have you enabled the 172.16.65.60 as a subscriber in the publisher server?

regards,

Sérgio Monteiro
Trust in no Oracle

nthphuong
Starting Member

5 Posts

Posted - 2003-08-13 : 07:15:51

Hi Sérgio Monteiro

My problem is DNS doesnot broadcast through VPN, it's only add one line in file winnt\system32\drivers\etc\hosts with IP & SERVER-NAME of server 2 that solve the error

Thanks for your helps
Phuong

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources