RE: Snapshot Agent runs, but merge agent will not start(never started)

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

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

Date: Thu, 18 Mar 2004 01:36:08 -0800

Joe,
there is an article about troubleshooting these errors:
http://support.microsoft.com/?kbid=834124 that you might like to look at.
The relevant section explains:

The following list describes two possible causes for this problem.

The SQL Server service uses an account that does not have sufficient administrative credentials on the Windows domain. In this situation, the xp_logininfo system stored procedure is run by using the security context of the SQL Server service. Because the account does not have sufficient administrative credentials to enumerate the properties of the user in the domain, the xp_logininfo system stored procedure fails, and you receive the 8198 error.
To resolve this problem, change the startup account of the SQL Server service to a Windows domain account.

The SQL Server services and the SQL Server Agent services on the Publisher and on the Subscriber use security contexts of different Windows domains.
To resolve this problem, use either of the following two methods.
Use the same Windows domain user account to run the SQL Server services and the SQL Server Agent services.
Create a Windows domain user account on the Publisher and on the Subscriber that have identical user names and passwords.

If you try the recommended solutions and have no success there is a known issue and hotfix available:
http://support.microsoft.com/default.aspx?kbid=830596.
HTH,
Paul Ibison

Relevant Pages

  • Re: SQL2k5 local rights to use
    ... I suggest you to create service accounts for your SQL Server services and set these service accounts to your SQL Server services using SQL Server Configuration Manager. ... To be a System Administrator for your SQL Server instance, you can add your domain account to the "sysadmin" Server Fixed Role. ...
    (microsoft.public.sqlserver.setup)
  • RE: Domain or Local User Account for Laptop SQL 2008 Services
    ... I think I'd like to use a Domain User Account for the SQL 2008 services, but if I do this, will SQL Server function properly when I'm not connected to my network? ... SQL Server will try to connect to your domain controller for establishing authentication at startup if you configured your SQL Server service to a domain user account. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • Error Set objWMIService : The remote server machine does not
    ... TO check the SQLServicesHeartbeat of all SQL Server services and ... objMessage.Subject = "SQL Server Services Notification" ... 'Name or IP of Remote SMTP Server ...
    (microsoft.public.scripting.vbscript)
  • Re: Linked Server Connection Error: 18459
    ... Did either of your SQL Server instances run under a domain user account? ... I recommend that you first ensure that your SQL Server ...
    (microsoft.public.sqlserver.connect)
  • Re: Windows authentication/impersonation.. login failed for user null?
    ... You must make sure that domain user account or the domain security group ... ia mapped to a SQL server login/Sql Server ... database user. ... and then make specific SQL Server login as ...
    (microsoft.public.dotnet.framework.aspnet)