OK, with a tip from ChrisR I got the first problem fixed (I hope). Now, I have
another problem. I have created a pull subscription on a second server, say
SERVERB, to get the data from the first server, say SERVERA. Every time I try to
run this pull subscription I get the following message:
The process could not connect to Subscriber 'NEWSERVERB'.
Then it fails every time. Funny thing to me is that then name of the subscriber
in this message is my subscriber server with 'NEW' on the front. Questions:
Where does that name come from? Why is it trying to connect to my subscriber?
What the heck is going on?
Thanks!
Hi Darrell,
It looks like '-Subscriber NEWSERVERB' might have been accidentally added to
the command line for starting the replication agent. You can find out the
replication agent command line by doing a select from msdb..sysjobsteps.
Merge agent job steps will have a subsystem value of 'REPL-MERGE' whereas
distribution agent job steps will have a subsystem value of
'REPL-DISTRIBUTION'.
-Raymond
"Darrell" wrote:
> OK, with a tip from ChrisR I got the first problem fixed (I hope). Now, I have
> another problem. I have created a pull subscription on a second server, say
> SERVERB, to get the data from the first server, say SERVERA. Every time I try to
> run this pull subscription I get the following message:
> The process could not connect to Subscriber 'NEWSERVERB'.
> Then it fails every time. Funny thing to me is that then name of the subscriber
> in this message is my subscriber server with 'NEW' on the front. Questions:
> Where does that name come from? Why is it trying to connect to my subscriber?
> What the heck is going on?
> Thanks!
>
|||Dude, thanks! I thought I had changed that in the steps of all jobs. I must have
missed one or more of the steps. Thanks again.
Raymond Mak [MSFT] wrote:[vbcol=seagreen]
> Hi Darrell,
> It looks like '-Subscriber NEWSERVERB' might have been accidentally added to
> the command line for starting the replication agent. You can find out the
> replication agent command line by doing a select from msdb..sysjobsteps.
> Merge agent job steps will have a subsystem value of 'REPL-MERGE' whereas
> distribution agent job steps will have a subsystem value of
> 'REPL-DISTRIBUTION'.
> -Raymond
> "Darrell" wrote:
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment