Snapshot agent: The process could not connect to Distributor 'SERVER1'

From: Michael (mike_at_fivestardvd.com)
Date: 02/18/04


Date: 18 Feb 2004 11:19:24 -0800

I have used Enterprise Manager to configure replication on SERVER1.
SERVER1 is the Distributor and the Publisher. SERVER1 is a SQL Server
2000 that runs in mixed mode (SQL and Windows Authentication). The
SQL Server and SQL Server Agent startup accounts are the same which is
also a local user account that has administrative privileges.

I am completely stumped why I am having these permissions issues when
everything is being done on the local machine.

Any advice would be greatly appreciated.

Thank you.



Relevant Pages

  • RE: Access SQL Server from Stand-Alone PC with Windows Authentication
    ... If the machine is in a workgroup, SQL server machine is in the domain, make ... Create a same Local user account both on the machine and the SQL server ... you can access the SQL server via Query Analyzer with Windows ... SQL authentication. ...
    (microsoft.public.sqlserver.security)
  • SS05 : use local user account for services account ?
    ... Apparently it's not possible to use a local user account as the service account for the SQL Server 2005? ... I'm installing on a standalone laptop that's not a member of any domain. ...
    (microsoft.public.sqlserver.setup)
  • Re: Regarding setup for SharePoint Services 2.0...
    ... But after installation, all WSS functionality will ... continue to work if you switch back to Mixed Mode. ... like) that get real flaky if you are not running in Windows Only SQL Server ... advantages to Microsoft from a security perspective moving to a Windows Only ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Regarding setup for SharePoint Services 2.0...
    ... that means it's OK to set up SQL Server ... authentication as mixed mode when installing WSS? ... > following the single-server installation guide for that product. ... > mode or when wondering if mixed mode is a solid solution. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Regarding setup for SharePoint Services 2.0...
    ... For what it's worth I've just done a Project Server 2003 installation ... to the SQL Server 2K installation part of the guide it stressed that SQL ... Server 2K must be installed in mixed mode because you were going ... > advantages to Microsoft from a security perspective moving to a Windows ...
    (microsoft.public.sharepoint.windowsservices)