Re: cannot deliver sp_repldropcolum schema change

I'm not familiar with the normal log messages, but it looks like you have
configured a proxy account. Is the proxy account that the merge agent is
using in the Local admins group on the server? (or at least set up with the
necessary rights)? (it's generally much easier to have the merge agent run
as the sql server agent although SQL Serever 2005 uses these proxies by
default) Also, is there enough space on the server?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .


.

Relevant Pages

  • Re: Authentication on indexing service as a linked server
    ... So basically that means that when querying through SQL server, indexing ... > The proxy account is used as the security context. ... > Server agent service account. ...
    (microsoft.public.inetserver.indexserver)
  • Re: Network traffic with transactional replication with immediate updates (SQL 2005)
    ... publisher/distributor running on the main office and a subscriber at the ... This is a new SQL Server 2005 behaviour, ... the agent should execute them (maybe the agent just ... I cannot find a way to explain why Distributor Agents are to ...
    (microsoft.public.sqlserver.replication)
  • Re: Network traffic with transactional replication with immediate updates (SQL 2005)
    ... publisher/distributor running on the main office and a subscriber at the ... the agent should execute them (maybe the agent just launches ... Looking for a SQL Server replication book? ... I cannot find a way to explain why Distributor Agents are to ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Server 2005 replication monitor questions
    ... >> To get to the agents expand SQL Server Agent jobs, ... click on your publication in Enterprise ... >> bottom half you will see your snapshot and distribution agent. ... >> monitor it there (through replication monitor). ...
    (microsoft.public.sqlserver.replication)
  • Re: Server CE 2.0 Merge Replication
    ... This morning I am not able to access sscesa20.dll both from the emulator nor ... To change your connection settings, ... > your first goal should be to access the server agent from Pocket IE ... >> My SQL Server instance name be YYY ...
    (microsoft.public.sqlserver.ce)
Loading