Re: The process could not connect to Subscriber 'Server2'

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 04/07/04 

Date: Wed, 7 Apr 2004 19:00:35 +0100

Ajit,
normally this means that you are trying to use SQL Server security and the
server is set up to only allow Windows logins. If this is the case, you can
make your agent impersonate the SQL Server agent account or alternatively
switch the server to allow mixed authentication. If you have updatable
subscribers it would mean something different - that you have to use
sp_link_publication.
HTH,
Paul Ibison

Relevant Pages

  • Re: Autostart MS Agent on Win98/Me
    ... If you really rely on SQL Server Agent being started and you have not a lot ... > with Entreprise manager and the agent start with WinNT... ... I can manually start the agent with the MSDE service manager, ...
    (microsoft.public.sqlserver.msde)
  • Re: Can MSDE run SQL Server Agent service in Win98
    ... >> SQL Server Agent service. ... > AFAIK the SQL Server Agent runs on Win9x with no problem..... ... > run as a service becouse Win9x does not support it, ...
    (microsoft.public.sqlserver.msde)
  • RE: DTS Package fails when Scheduled
    ... Make sure SQL Server Agent account has the correct rights/permissions. ... scheduled job under this context, I still received the error, even though I ...
    (microsoft.public.sqlserver.dts)
  • Re: Error running DTS package on a schedule (only!)
    ... Right Click on the SQL Server Agent icon in EM and choose properties. ... > How do I determine which account was used to start SQL Agent? ... >> | When I try to schedule a job for this DTS package under SQL Server ...
    (microsoft.public.sqlserver.dts)
  • Re: Win 2003 upgrade
    ... Then I would start it up SQL Server agent and see if I can't identify the ... For the problem with the retention period of expiring subscribers, ... 'The subscription has not been synchronized within the maximum ...
    (microsoft.public.sqlserver.replication)