Given two servers in different data centers (DCs), if the computer name as shown by SELECT @@SERVERNAME or NET CONFIG WORKSTATION is the same, but the FQDN is different, replication cannot be implemented because service authentication appears to only consider
the computer name.
For example: sqlserver.dc1.domain.net and sqlserver.dc2.domain.net are in different locations, and can communicate on port 1433. But all attempts at transactional replication or mirroring because the computer name "sqlserver" is equivalent.
Have tried SQL aliases and hosts file entries, but without success. Any suggestions?
Connect entry: http://tinyurl.com/33wjnmx
View Complete Post