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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2008-05-29 : 14:16:35
|
| is synchronization possible between databases in different domains (and different servers) |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-29 : 22:06:11
|
| Yes. what is your requirement? |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-05-30 : 01:09:54
|
| I have 2 servers - I want to synchronize from server A to server B.they are not in the same domain - both have sql server 2005 |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-30 : 09:44:09
|
| Yes, you can do . |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-02 : 22:10:07
|
| Depends on how you sync them. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-06-03 : 03:37:35
|
| can you tell me what you suggest?I tried transactional replication but it failed - in what way do I have to do it that it will work.can anyone with experience share what worked to save me all the time and trials that don't work. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-03 : 10:48:47
|
| What error did you get? Does both servers have same SQL agent service account ? |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-06-03 : 11:43:04
|
| how do i know if they have the same sql server agent account?I deleted it as it didn't error but in the server events log - I saw an error with the update |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 15:46:20
|
| You can find sql service startup account in sql configuration manager. Try create an account with same name and password in each domain, start sql services with that account then try set replication again. |
|
|
|
|
|
|
synchronization between databases in different dom