SQL replication with Remote SQL server

Kailash Aghera
Kailash Aghera used Ask the Experts™
on
Hi,

I am trying to create MSSQL 2008 replication on my local MSSQL server to remote SQL server(server is in data center). The remote MSSQL 2008 server has SQL 2008 express edition installed (subscriber role for replication). I tried to add subscriber from my local MSSQL server but I received 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, 'myremotemachinename\SQLEXPRESS'. (Replication.Utilities)

How can I add my remote SQL server as a subscriber in my local MSSQL server? The name of my remote MSSQL server is just machine name i.e. "Dev-machine" and it can't be resolved by name worldwide.

Is it possible to add remote MSSQL server as a subscriber?

Thanks,

Kailash
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ill

Commented:
registering SQL Express in local SSMS works? Datacenter provider should have ports open for SQL.Try using IP instead of a name.
Kailash AgheraTeam Lead

Author

Commented:
Hi,

I will try your suggestion and will let you know.

Thanks,
Kailash AgheraTeam Lead

Author

Commented:
Registered the server in my local system and it didn't work. Required port is opened. Unfortunately I can't use IP address while adding subscriber for replication.. If I use IP address it gives an error "SQL Server replication requires the actual server name to make a connection to the server......."
Commented:
In this case, try create VPN between the servers( again, provider must support VPN) and bring the remote server home(vpn behave like local network)
Kailash AgheraTeam Lead

Author

Commented:
Hi,

VPN is a good idea but I got it working now without VPN. I added my local server as an alias in my remote server and vice-versa. And then I added the host entry (hosts file in my system32 directory) to resolve hostname to my SQL server IP address in my local system. It's working fine now.

Thanks,

Kailash

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial