Transaction Replication Problem
-
I have 2 SQL Server 2000 with SP4 instance in different location.
Both the Servers are Windows 2003 Standard edition with SP1. Both the servers are NOT in Domain controller. They are in Different Workgroup, But in Same LAN.
We have good amount of bandwidth allocated for connecting one location to other.
I am facing problem to setup Transaction Replication between these 2 location.
Do I need to map the REPL data folder where my subscriber database resides?
Please help me. Also if you need any further input surely I will provide immediately.
Please respond urgently.
Regards,
Chandan Laskar
09830057396(M)
-
so nice
Kindest Regards,Anil Kumar
-
Hi Anil,
Not Understood what you meant to say
Regards,
Chandan Laskar
09830057396(M)
-
Please help me as I am new in Replication.
-
Generally the REPL folder goes on the publisher/distributor, but it doesnt really matter as long as the drive has enough space for what you need to do and both servers can get to the share.
-
Thanks Andy,
It Means if subscriber cannot physically access REPL folder in publisher/distributor end then Replication will not work.
In that case if my 2 SQL Server machine under the different firewall and security team does not allow to open Windows File sharing port (e.g. 135/137) then can I not setup Replication at all?
-
Im spoiled, all my repl work has been inside a domain!
There are some options:
- SQL 2005 has a web option for merge you might look at
- You can use FTP for the snapshot (requires a different port, I doubt they will like this any better)
- You could copy the snapshot manually, usb key, dvd, whatever, somehow get it to the subscriber
- SQL 2005 allows you to init from a backup (which is a variation on copying the snapshot manually for our purposes). Even in SQL 2000 you could init from a backup as long as you prevented changes to the publisher until repl was live (again, a variation of copying the snapshot
- Have the network guys set up a VPN
- Do an end run by creating your own VPN (http://www.hamachi.cc)!
All are more work than having them allow the file copy. Before you do the alternatives, you might try them one more time - they can make the rule pretty tight, allow ports only from/to those two machines, and you supplement it with good NTFS permissions on the disks. You could even have them allow it only for the initial snapshot, then disable the rule - just make a note about what to do if you need to snapshot again.
Copying it manually is an ok solution, but they will either have to authorize another machine (yours or some type of admin kiosk), or they will have to allow physical access to the subscriber (either you or them).
If you get it going I hope you'll post your final solution.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply