SQLTeam.com | Weblogs | Forums

Snapshot Replication Across Domains


#1

Hi all,
I need to set up snapshot replication from SQL Server A (2008 R2) on Domain A and Server B (2012) on Domain B.

I have linked servers configured and I'm able to copy tables from one server to the other. That works.

I was able to configure the publisher on Server A but I get an error when I try to create the Subscriber on Server B. (Sorry I don't have the exact error in front of me)
Are there any special considerations when configuring snapshot replication from one domain to another?
Thanks


#2

Well one thing: both publisher and subscriber need access to a common storage area.

Oh, please locate and post your error messages.


#3

Thanks gbritton.

  1. Can the snapshot file reside on either the publisher server or the subscriber server? Or does it have to be at an ftp site?

  2. When I attempt to create the subscription, I get error
    "SQL Server requires the actual server name to make a connection to the server. Specify the actual server name."

I've done that, even tried the IP address.
Note: from the subscription server, I AM able to query tables that reside on the publisher server by using 4-part naming. Linked servers have been created.


#4

This link seems to address your problem


#5

Thanks gbritton. I had found that article last week but unfortunately, it doesn't help in my situation.
Select @@servername returns the actual current server name. It doesn't appear to have ever been renamed.


#6

please post the t-sql you use to add the subscription


#7

gbritton, I used the GUI. These servers are on trusted domains. I think I'll drop the publication and re-add it but this time placing the snapshot file on a file share that my subscriber has access to. I'll post back with the results. Thanks for your interest.


#8

When you use the GUI, check out the Script button at the top. It should generate the T-SQL for your operation


#9

Please check your cross domain access and firewall setup, ports are open and listing each other.