I want to enable one - way incremental replication between two SQL servers but there is a third server between the two. I want to use push replication as two computers won't be always connected.
There are two local 2000 servers and third 7.0 is on the web.
Client wants that main local server where main database is located and changes etc. are made should not be directly connected to server on the Web.
He says that he will take the backup of database from main server everyday and copy it to a second local server which will work as a publisher.
Will replication work if database on the publisher is replaced everyday? Or replication will have to be configured everyday and all the contents will again be replicated to server on the web.
Is there any other way to make this setup work without any complications.
The solution I think is to also enable replication between the two local servers but then again the main database server will be connected to the Internet indirectly.
To avoid that can I use the second local server just as a proxy server. If yes how to configure Main local sql server (which has the database) to use proxy server (Not MS Proxy Server) to connect to Internet for replication. I have read the MS Articles but they use MS Proxy Server.
--> ...
2004-04-08 13:28:54.15 server SQL server listening on 192.168.0.4:1433, 127.0.0.1:1433.
The internal sql-server system seems fine...
(192.168.0.4 -- is in the internal reserved address range, 127.0.0.1 is the localhost connection).
Ms Article uses 2 nic cards.
--> Only on the Proxy Server !, We do not need to worry about this (really we do not)
Should I use external IP address of the proxy server in the Server Network Utility under WinSock Proxy?
No, as detailed in the article you use an internal address of the server and setup the proxy server to transfer from the external address -> internal address/routing.
--> And you will need to add an alias for the external server, as previously detailed
You will probably need to cover how ms-sql server connectivity troubleshooting:
http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fwebcasts%2Fen%2Fwc020603%2Fwct020603.asp
Question is about replication using proxy and not about designing database. Main thing is USING PROXY.
-- I believe this to be answered, I believe you have a different problem, it looks like it is not a proxy issue.
Still Internet Server is not found by enterprise manager. Did you add in your client network config ?
This is mentioned in the article.. .using the client network config (on your client machine..) the external address presented on the internet by your second proxy server (or the external address of the machine)?
...End of responses to this Q.