Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 : publisher1.drsite.mycompany.com

Distribution Server : distributor1.mainsite.mycompany.com

Subscriber Server : subscriber1.mainsite.mycompany.com

When I try to add publisher1.drsite.mycompany.com 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 stackoverflow.com Jan 26 '12 at 2:51

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

add comment

1 Answer 1

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

share|improve this answer
add comment

Your Answer

 
discard

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