Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.