Viewing post 1 (of 2 total)
The passwords is correct.
I already figure it out. For the sys.sp_addloggreader_agent, I explicitly add @publisher_loging and @publisher_password. I also add explicitly @status=N'active' in sp_addsubscription.
Thank for your suggestion!
September 21, 2007 at 2:30 pm
#735370