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.
| Author |
Topic |
|
farhaniqbal
Starting Member
1 Post |
 Posted - 2007-11-26 : 00:22:50
|
| I have following configuratiions1. Two trusted domains(Domain 1 and Domain 2) connected through 128kbps intranet in two different buildings.2. A Computer(Machine 1) running SQL server 2000 connected with Domain 1.3. An application which connects to sql server and with its related database on Machine 1.4. I want to replicate data onto a computer (Machine 2) on Domain 2.so that users of domain 1 and domain 2 can have a synchronize database. And whenever they visit each other in different building they have their data availabe to them.Please Help |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-26 : 05:40:03
|
| You will need to add your service account to the second machine (as far as I remember). This should allow you the access you require. Either that or set the second machine up as a linked server on the first machine. |
 |
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-26 : 09:59:39
|
| You may need to use the IP address, but should work!Dave Dunckley says there is a law for the rich and a law for the poor and a law for Dirty Davey. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-27 : 02:20:19
|
| May see big latency if server is busy. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-12-11 : 12:34:17
|
| have you checked merged replication?or maybe you don't really need replication but a simple DTS package would suffice?it all depends on how much data you need reflected across sites--------------------keeping it simple... |
|
|
|
|
|
|
Replication in different trusted domain