question

Pratik avatar image
Pratik asked

Need help on setting Replication btw 2 different domains in SS 2008

Hi, I want to set up replication on 2 computers which are in different domains. One way I found was to run SQL Server agent accounts with same user for both servers but I can't do that as there is already one replication set up on Subscriber machine. So any other way to do this ? Plz Help. Cheers, Pratik Mehta
replication
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
WilliamD avatar image
WilliamD answered
Hi Pratik, take a look at [this HOWTO from MS][1] The options would be to: 1. Impersonate the Service Account at each location 2. Use SQL Authentification instead of Windows Authentification I think you may need to remove the subscriber and recreate it to do what you are wanting though. [1]: http://support.microsoft.com/kb/321822
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image WilliamD commented ·
If so, could you please mark this question as answered?
2 Likes 2 ·
Pratik avatar image Pratik commented ·
Thanks mate.... that was really helpful. After setting that, it was ipsec issue as well. so got it resolved.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.