Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to setup transaction replication between two domains under the same active directory. The publisher server is in a DR site domain and the remote distribution server is in the main site domain with the subscriber. Here are the machine names

Publisher Server :

Distribution Server :

Subscriber Server :

When I try to add to the remote distributor, it will not accept the FQDN and gives me the error below under Replication.Utilities

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, "publisher1"

Does anyone experience the same problem and know how to solve it?

share|improve this question

migrated from Jan 26 '12 at 2:51

This question came from our site for professional and enthusiast programmers.

You need to add a CNAME in your DNS at your primary SERVER putting the DR server's hostname. This way can be resolved. Then use publisher as the hostname to use when connecting.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.