Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
betesh
Starting Member
34 Posts |
 Posted - 2008-06-19 : 22:41:00
|
| Thanks everyone for being helpful. I am new to SQL Server and don't have many coworkers so I am relying heavily on this forum's help.It seems the previous poster on this issue was able to work it out but I am still not able to get it to work.I have tried using the server URL, the server machine name, the ipaddress with alias, but still cannot connect with the replication over vpn. Any ideas?Also, how can I set the subscriber from the server? How do I refer to the subscriber machine? Let's say it is my pc that I want to make changes in and have them replicate to the server? When I specify a pull subscription I am not show how to refer to my computer. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-19 : 23:10:11
|
| What's sql port? Is it open on your vpn? |
 |
|
|
betesh
Starting Member
34 Posts |
Posted - 2008-06-22 : 03:48:14
|
| How do I know? I know that the users are able to connect to the database and use an MS Access application that connects to the database. Just the replication doesn't work because it doesn't allow ipaddress. |
|
|
|
betesh
Starting Member
34 Posts |
Posted - 2008-06-22 : 04:27:01
|
| Finally the solution was found by my coworker - to update the LMhosts file with the ipaddress and machine name of the server. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-22 : 17:06:14
|
| Don't need lmhosts file if connect to sql server with ip address and port number. |
|
|
|
|
|
|
Replication over VPN part 2