Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2013
    Posts
    2

    Question Unanswered: New Topic Publication and Subscription issues over 2 domains

    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.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Are you using only the AD account name "RemoteAccount" or a FQDN, or an NT name like "RemoteDomain\RemoteAccount" to log into the remote domain? My preference would be FQDN then NT Name, the Account name by itself probably won't work.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Mar 2013
    Posts
    2
    Just a Update.

    The issue was with permissions, using the Single sign on would prevent me from signing in through the firewalls between both sites.

    To get around this I configured a Trusted connection between the 2 firewalls. and then from the FTP I allowed Annonymous from the specific IP address only.

    This let me grab the files i wanted and needed.

    Thus far been going fine, without error

Tags for this Thread

Posting Permissions

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