asked on

SQL replication with Remote SQL server

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

ill

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

Kailash Aghera

ASKER

Hi,

I will try your suggestion and will let you know.

Thanks,

Kailash Aghera

ASKER

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......."

ASKER CERTIFIED SOLUTION

ill

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Kailash Aghera

ASKER

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