Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    New York

    Question Unanswered: Replication Agent Login Failed

    We hope to do replication between two MS SQL Server 2000. We met following error message when we try to run the agent:

    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. The process could not connect to Distributor 'PROD-NY'. The step failed.

    PROD-NY is a local MS SQL Server 2000. I run it from enterprise Manager. The window login account is Administrator and the Local server is visited by sa. The machine running on Windows 2000 server and in a workgroup.

    Could someone figure out what i can do to fix this problem? Why the ANONYMOUS is used?



  2. #2
    Join Date
    Aug 2002
    Have you changed the password recently?
    Vyas KN
    You may get into this situation, when you configure your replication agents to log into the publisher and/or subscriber using "SQL Server authentication" (where you specify a specific SQL Server login, to connect to the publisher and/or subscriber). It will work fine initially, but when you change that particular login's password, you get the above mentioned errors. To solve this problem, whenever you change that particular login's password, make sure you change the password in the enabled publisher's and/or enabled subscriber's properties on that distribution server.

    To change the publisher's properties:
    - Open Enterprise Manager
    - Connect to the Distribution server
    - Go to Tools -> Replication -> Configure Publishing, Subscribers, and Distribution...
    - Go to Publishers tab
    - Click on the properties button (...) against the publisher's name
    - Enter the new password for the SQL Server login.

    To change the subscriber's properties, repeat the same steps as above, but in step 3, go to Subscribers tab.

    Restart your agents, and they should be able to connect to the publisher/subscriber without any errors.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts