Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer

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

Your Answer

 
discard

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.