SQL Server 2K Transaction replication in diffrent domain issues

• Brij Mohan

  SSC Journeyman

  Points: 89

  More actions

  November 4, 2008 at 10:58 pm

  #383305

  Hi,

  I am trying to do replication within publisher and subscriber located in diffrent domains (one is live and other is backup), details of which is given below;

  I have registered both the servers in Live Server. with SQL Server Logins, and the process of both the servers are running in their NT Authentication.

  Replication Type :Transaction (with updatable subscriber), Immediate Changes.

  Issue : I am able to update the Publisher and able to view the changes in subscriber, but the other way when I am updating the subscriber, I am getting SQL Server does not exists or access denied.

  I am desperately looking for the solution now, If anyone knows even partial solution also please let me know, if you need more details let me know.

  Thanks in Advance

  Brij Mohan

• Jo Pattyn

  SSC-Dedicated

  Points: 32515

  More actions

  November 5, 2008 at 1:50 pm

  #894515

  Hello,

  Verify the permissions of the Windows accounts the replication jobs run under. (and also the linked server permissions)

  It could be a oneway domain trust.

  There is also something like the Windows Authentication Double Hop issue (see the web).

  If the replication works with only sqlserver accounts (also for the sqlagent), then there is a misconfiguration in the windows authentication setup.