sql server replication: Hi,

i configured the sql servers in transactional replication.
but when i insert the second server which is subscriber to
first one, it is giving error as sa login failed.

advise me,

thanks,

Hi,
Can you give us more information about the setup of your replication? Is it
push or pull? Which agent is failing with "Login failed for user 'sa'"?
error message. Is it the distribution agent or a different agent? Please
configure the output file on the replication agent as per the following KB
article and post the output here.
312292 HOW TO: Enable Replication Agents for Logging to Output Files in SQL
http://support.microsoft.com/?id=312292

Regards,
Ramu.


This posting is provided "AS IS" with no warranties, and confers no rights.