The company I work for is in the process of creating collaboration among 3 domains. I have been tasked with setting up snapshot replication between SQL Servers on 2 of these domains from a 3rd. Furthermore the distributor is SQL Server 2000 and the subscriber is SQL Server 2014. I am finding that this may be more complicated than I originally thought.
First of all I don't seem to be able to even get started with setting up the distribution. When I click to configure distributions I get the following error:
SQL Server is unable to connect to server 'sqlserver1.companyname.com'.
SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name, 'sqlserver1'.
I am thinking this may be related to the fact that I am having to connect using the FQDN of the server instead of the server name, but I am stumped after considerable research as to where to go from here. There also may be permission issues as I am logged in using credentials provided to me from admins on the other domain.
Supposedly all three domains have trusts enabled and we do have users logging in between domains.
Any insights would be greatly appreciated.