Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to create a subscription to a remote server having SQL 2008 R2

the client PC is connected through VPN to the server and can discover it successfully.

I can even connect to the database through SSMS with no issues, after having fixed the hosts file to translate the server name into its public IP address. I am using SQL Authentication to avoid cross domain issues. Both machines are not on a domain.

The problem is when I want to add a new subscription and choose a publisher, I cannot as it requires the actual server name.

I tried some workarounds like using an Alias and using that but still didn't work

Is there any way around this ?

share|improve this question

Not sure if this will solve it, but try adding an entry into the client PC's hosts file:

# replace values here with IP of server, name of server
192.168.1.101   db-server-name

Then you can try using the server name, "db-server-name", when adding a new subscription.

share|improve this answer
    
already did that (mentioned in the question : "after having fixed the hosts file to translate the server name into its public IP address") – Anthony Mar 20 '13 at 23:27

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .