SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Publication and Subscription issues over 2 domains
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

2 Posts

Posted - 03/28/2013 :  05:30:22  Show Profile  Reply with Quote
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.

Starting Member

2 Posts

Posted - 06/04/2013 :  09:04:23  Show Profile  Reply with Quote
I Manged to get around this eventually.

What i did was configure a trusted connection between the 2 firewalls.
And then I allowed annonymous connection from the specific IP address only.

This allowed me to grab the files from a FTP site, and process correctly.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000