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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-25 : 08:15:39
|
| Rick writes "I need to replicate several SQL 2000 sp3a databases in DOMAIN A to a consolidation server in DOMAIN B. Both domains are physcially close togehter (no internet connects). I want to keep security between the two domains as tight and restrictive as possible while still allowing the replication. I have searched and found zero info on this topic." |
|
|
mblythe
Starting Member
16 Posts |
Posted - 2005-08-25 : 17:48:51
|
| This was not documented in SQL Server 2000 BOL. You can either use Windows or SQL Auth to accomplish this. WindowsIf you use Windows to make connections, all agent connections will be made under the context of the SQL Server Agent account at each node. Ensure there is a local Windows account (not a domain account) with the same login and password at each node. Run SQL Server Agent under this account and specify that Windows should be used for all connections.SQL AuthIf you use SQL Auth to make connections, you can run SQL Server Agent at each node under any account that has the appropriate permissions. To use SQL Server Authentication:* Add a SQL Server account for each agent at the appropriate nodes (use the same account name and password at each node). For example, the Distribution Agent for a push subscription runs at the Distributor and makes connections to the Distributor and Subscriber. The SQL Server account for the Distribution Agent should be added to the Distributor and Subscriber.* Ensure that a given agent (for example the Distribution Agent for a subscription) makes connections under the same account at each computer.* If you can't use UNC paths, transfer the snapshot to Subscribers through file transfer protocol (FTP).Michael Blythe Technical WriterSQL Server Replication - Microsoft --------------------------------------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. |
 |
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2005-08-26 : 16:48:09
|
| How about:http://support.microsoft.com/?id=321822 |
|
|
|
|
|
|
Replication across domains