Yes, adding server on hosts works fine but only for the default instance.

For the databases on the named instance you must set and use the alias.

If your destination server is named instance e.g. destservername\mssqlserver01, the solution for this can be found at:

http://www.sqlservercentral.com/Forums/Topic759989-291-1.aspx

Found the solution:

Go to SQL Server Configuration Manager of your client computer (In my case one in the corporate network)

Select SQL Native Client Configuration

Select Aliases

Add a new alias:

Alias Name: mydbname\mssqlserver01...

Hi Roy,

Yes, you can create like that but without re-initialising the subscription/running the snapshot again, data from internal to external databases does not get pushed at all.

Hi noeld

Yes,...

Hi Roy,

Where can you specify that no Snapshot is needed on the Management Studio? I have failed to find this option.