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 |
|
tjwent69
Starting Member
30 Posts |
 Posted - 2008-11-05 : 10:53:23
|
| I need to know if it is possible to replicate across two domains.I have SQL db on a domain called North with a Prod database.I have SQLExpress db on domain called South that I replicate the prod db to.I have added the south\Domain users to the SQL security and then in the prod db security I have added the merge roles and db_owner. Everything looks as though it should work. I am really hoping I am just missing some security somewhere. |
|
|
tjwent69
Starting Member
30 Posts |
Posted - 2008-11-05 : 10:53:57
|
| I forgot to add that the domains are trusted. |
 |
|
|
petek
Posting Yak Master
192 Posts |
Posted - 2008-11-13 : 03:31:19
|
| Hi mate,You need to add it to the dbcreator role as well.I have recently got my snapshot replication working and it works for me.I also created a local windows account on both machines with the same name and added them to the administrators group, then used this account for replication on both publisher and subscriber.Kind RegardsPete. |
|
|
|
|
|
|
Replicate across two domains