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
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.
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
"Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
news:uQaA9zy4GHA.3732@.TK2MSFTNGP05.phx.gbl...
> 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
>
No comments:
Post a Comment