1

I have a server that I wish to set up a subscriber on, however the publisher lives on a different domain controller and is not in the primary DNS.

To access the server, a FQDN needs to be provided. so publisherServer becomes publisherServer.something.local

when trying to add a subscription, I get the following error:

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name

How can I set up a subscription, when the server name publisherServer does not resolve from the server I wish to subscribe from.

1

I can set up the subscription if I add the server name and ip into the hosts file.

Not pretty, but it works.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.