SQL Server Performance Forum – Threads Archive

sql server 2000 trans. rep.

Setting up this in a 2 server domain environment. ServerA (publisher & distributor)
ServerB (subscriber)
How should security be setup on each server(MSSQLServer & SQLAgent)
If local/domain user(s), do need to add these to Enterprise Manager on both boxes also?

Setting up this in a 2 server domain environment. ServerA (publisher & distributor)
ServerB (subscriber) — Fine till here
How should security be setup on each server(MSSQLServer & SQLAgent)
— Read below links, it contains detailed information you asked for:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replsec_8dix.asp
http://www.databasejournal.com/features/mssql/article.php/3391321
If local/domain user(s), do need to add these to Enterprise Manager on both boxes also?
— I am unable to understand it..can you please re-write this question with more details. Deepak Kumar –An eye for an eye and everyone shall be blind

Ensure both the domains are trusted to each other and both the users has required privileges.
http://www.sqlteam.com/item.asp?ItemID=669 for furhter information on TR. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>