Replication Issue

• mthomas

  SSC Enthusiast

  Points: 106

  More actions

  July 5, 2005 at 3:28 am

  #89934

  Hi Guys

  I have replication established between a number of SQL 2000 instalations across multiple domains and all works fine. However, periodically I get and error in replication "Login failed for user null Reason: not associated with a trusted connection." If we recreate the trust all works fine again for a while. What I don't understand is why we periodically lose the trust relationship. Any suggestions or explainations would be greatly appreciated.

  Many thanks

  
  m t thomas

• SQL Draggon

  Right there with Babe

  Points: 766

  More actions

  July 7, 2005 at 9:49 am

  #571914

  I'v had the same error happen periodiocally, but not really sure what the cause is . usually stopping and starting the SQL agent seems to fix it .

  good luck..

  ---

  Don't count what you do, do what counts.

  SQL Draggon
  

• jason_fife

  SSC Enthusiast

  Points: 174

  More actions

  July 7, 2005 at 10:00 am

  #571929

  I believe linked servers are required for replication.  How are your linked servers set up between publisher(s) and subscriber(s)?

  Jason

• Sanjay Pathy

  Newbie

  Points: 8

  More actions

  July 7, 2005 at 10:13 am

  #571942

  Check if the security is set for SQL server and windows authentication and audit level set to none. Probably this work fine. good luck