Hello room,
I setup a transaction replication between SQL 2000 (Publisher and Local Distributor) and SQL 2005 (Subscriber).
I run into an error:
Msg 18483, Level 14, State 1, Procedure sp_adddistributor, Line 130
Could not connect to server 'SERVER_A' because 'distributor_admin' is not defined as a remote login at the server.
Can anyone help on this? Thanks in advance.
Regards,
TJ