Distribution Agent Failing - Cannot connect to Subscriber

  • I get this message when trying to start the distribution agent.  It has been a while since I configured from scratch but the publishers looks like everything is set up correctly.  Any Suggestions?

    Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

    (Source: P10-DBSERVER2 (Data source); Error number: 18452)

    ---------------------------------------------------------------------------------------------------------------

    Thanks,

     

     

  • This was removed by the editor as SPAM

  • Check account settings for connecting from distributor to publisher (on distributor - publisher settings). If connects as NT account - check account exists on publisher, if connects as SQL account - check account exists on publisher and reset password to be sure it is the same on distributor and publisher. Also make sure that publisher exists in remote (linked) servers on distributor.

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

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