Run at Subscriber Logon Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Samuel Shulman - 28 Sep 2006 19:36 GMT

Hi all

Since I had some problems setting Push Merge Subscription I tried to 'Run
Agent at Subscriber' while setting it I clicked on 'Verify Subscriber'
button and I got the following error:

Server xyz 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: NT Authority/Anonymous logon

I set all services to run under the Domain's Administrator account i.e. The
Main database Service and the SQL Agent Service

What is wrong, is there a separate service that runs on the distributor side
or else

Thank you for your advice,
Samuel Shulman

Reply to this Message

Hilary Cotter - 29 Sep 2006 03:11 GMT

You have to configure the binary for remote activation. Type dcomcnfg from
the command prompt and the follow the below

1.. On the Applications tab, select Microsoft SQL Server Replication
Remote Merge Agent 8.0, and then click Properties.

2.. On the Security tab, select Use custom launch permissions, and then
click Edit.

3.. In the Registry Value Permissions window, add the account used to run
SQL Server Agent on the Distributor (for push subscriptions), or SQL Server
Agent on the Subscriber (for pull subscriptions), and then click OK.

4.. Click the Identity tab, select This user, and then enter the same user
account used by SQL Server Agent on the Distributor (for push
subscriptions), or SQL Server Agent on the Subscriber (for pull
subscriptions).

This is from remote agent activation in bol.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi all
>
[quoted text clipped - 15 lines]
> Thank you for your advice,
> Samuel Shulman

Reply to this Message