Server 'SQLTEST1' is not prepared to run the offloaded agent

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: jxstern (jxstern_at_nowhere.com)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 11:56:29 -0800

Maybe someone can give me a hint on this. 

--
Right-clicking on the distribution agent offers an option, "run agent
on subscriber".  I want to try that.
Box comes up that says "Subscriber must be prepared ..." and with a
button that says it will verify subscriber.  I click that and get an
error message:
Server 'SQLTEST1" is not prepared to run the offloaded agent.
Error 1040: The agent failed to connect to the Distributor due to the
following error. 'Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection.
--
Oh, yeah?
In BOL, there's a section on Remote Agent Activation that suggests you
have to go to the subscriber (SQLTEST1) and run DCOMCNFG.exe, only the
instructions don't reflect the DCOMCNFG.exe that exists on Windows
Server 2003.
Anybody have any hints for me what the problem is here?  
"user '(null)'"????
SQLAgent is running happily on SQLTEST1 and SQLTEST2 (publisher and
current distributor), using a domain account, and SQLTEST2 is pushing
a transactional replication happily to SQLTEST1, but I want to move
the distributor!
Thanx.
Josh
Quantcast