Publication and Subscription issues over 2 domains on WAN

  • Good Morning Ladies and Gents,

    I am struggling to win with Publications and Subscriptions.

    The situation is as follows, A client of ours has a system which requires updates received from an external domain (trusted connection is setup already) and pull data through a configured Publication.

    Now when I attempt to setup a pull subscription the problem I am running into is the OS level authentication the location for the snapshots they don’t want anonymous login, which I can understand from a security standpoint.

    But I continually have hit a wall when it comes to where I can define a Login details to utilize, both to a unc shared path or a FTP. On the OS level when I define it I receive an error because the account I placed in is trying to verify on the clients domain which won’t work because it is a completely separate domain as I have stated.

    The 2 SQL servers are communicating through a trusted connection over the Internet, and the FTP as well as the OS share I can access myself through Windows by entering the required credentials when asked for them so it definitely is not a case of no access at all.

    Any help would be greatly appreciated.

Viewing 0 posts

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