Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

How Hard can it be? Ive spent the last 4 hours googling just to find either nothing works, or people randomly posting information that 'sounds good'

My setup:

Two SQL2012 Servers, in two different locations (UK and US), Using Merge to transfer data between the two.

The UK server is going to be subscriber, From the UK server I can remotely connect to the US Server. However when setting up the subscriber and adding the US sql credentials I get

SQL Server – “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, ‘{ServerABC}’. (Replication.Utilities)”

So I added a record onto my host file (on the UK server) to map Ip to ServerABC I can ping "ServerABC"

I try to connect again to ServerABC, and get the same error.

if I do a select @@servername = "ServerABC"

What am I doing wrong?, ive spent so much time on this not getting anywhere - so frustrating! Please help

share|improve this question
    
Under SQL Configuration Manager>SQL Server Network Configuration, have you allowed Named Pipes to be enabled? In addition to this, run SELECT @@SERVERNAME and see if that matches the computer name –  Cold T Feb 14 '13 at 10:27
    
Named pipes enabled, do I run the select @@servername on the subscriber or the pub? –  D-W Feb 14 '13 at 10:47
    
Ok running select @@servername on the publisher (US server) returns SERVERNAME\SQL2012 –  D-W Feb 14 '13 at 11:03
    
Run this on both just to be sure. Can you confirm "SQL2012" is the computer name itself as well? –  Cold T Feb 14 '13 at 11:19
    
Ok im totally confused. –  D-W Feb 14 '13 at 11:31

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.