Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Milo Cold
Starting Member
14 Posts |
 Posted - 2005-06-01 : 13:42:10
|
Hello folks,So I'm stumped! I've got a SQL server (w/one instance) that has two lovely pull subscriptions to the same server in another building. Now after recently setting up the second sub, the original sub keeps pooping out getting stuck in 'retrys' before eventually just failing. The message received post-pooping is "Another distribution agent for the subscription(s) is running."After looking around the web for info, one site cliamed that this is caused by orphan agents (I think rogue agents sound better... but ehh). So I ran a query against sysprocesses and didn't find multiple processes running under the same agent name./*** New Thought ***/When setting up multiple subs, is it incorrect to choose "Impersonatethe SQL Server Agent account" for both of them in the select synch agent login screen? Could that be why one of these sub is seeing double? /*******************/If anyone has any advice I'd greatly apreciate it! Thanks in AdvanceM. Cold  |
|
|
|
|
|
Another distribution agent for the subscription(s)