Post reply

Agent Security doesn't appear in Transaction Replication

  • July 20, 2009 at 1:28 am

    #208482

    Sorry if my English isn't good

    I have 2 servers

    Server A - SQL Server 2000 SP4 Enterprise Edition

    Server B - SQL Server 2005 SP3 Enterprise Edition

    Server A : Publisher + Local Distrbutor

    Server B : Subcriber

    When I set up Transaction Replication, it works. But after 2 weeks, when I reinstall, it has error.

    At Creating Publication Step, after "Specify when to run the Snapshot Agent", it goes to Finished Step.

    "Agent Security" Step doesn't appear. So I can't configure username and password to connect to Subcriber.

    Finally, when I start replicating, it doesn't work. Error is " Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Cannnot connect to Subcribers."

    How can I fix that ? It worked, but now it doesn't. There must be someone's changed something but I don't know what has been changed ?

    Thanks for helping

  • July 20, 2009 at 3:13 am

    #1026819

    Right click on the subscription. Select properties. Under Security you can set Account name and password.

  • July 22, 2009 at 8:08 am

    #1028328

    Thanks for reply.

    I've tried but can you write more clearly ? Under Security in Subcriber, all Information's read-only and can't be changed.

    And my problem is the "Agent Security" step doesn't appear.

    I wonder which account that Publisher used to connect Subcriber ? Maybe it use the Windows authentica to connect and Agent Process run under Windows authenticated ?

    If so, what I have to do ?

    Thanks

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply