site to site VPN

Problem: I'm trying to do a software client installation on the remote end of VPN. The software uses MSSQL to network the database. I can't finish the installation because I can't get the MSSQL to see the host PC on the other end of the VPN. Configuration: Both host and client are XP Pro SP2. I have a VPN set up using 2 Linksys(WRVS4400N) Wireless-N Gigabit Security Routers with VPN. I have the firewall turned off on both XP machines. I know the tunnel is working because I can ping ip addresses on the other end of the tunnel. Neither side has access to a Domain Controller or any true server software. Any suggestions or ideas would greatly be appreciated.

Answer Wiki

Thanks. We'll let you know when a new response is added.

It sounds like the computer on each end can ping each other. If this is the case it may just be a DNS problem is there a DNS server on either side of the VPN. IF there is you may need to put a forward lookup zone to point to the othe DNS server.

Discuss This Question: 3  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Phorst
    There is no dns server on either end. In fact there is no true server OS software on either end.
    0 pointsBadges:
  • Mssmikey
    Assuming that what you mean is the MSSQL client software cant talk to the host server at the other end.... When setting up your database connection on the client software,be sure your specifying SQL Server authentication, not Windows (or integrated) authentication. Also - you'll likely have to specify the machine with the SQL server on it via IP address. not by name.
    30 pointsBadges:
  • Nephi1
    If your 2 PCs can ping each other, instead of using the PC name to connect to the MSSQL service, try using the Machine's IP address. Also Windows Authentication should work as long as it asks you for a user/password, or you have the user on the client also on the server. To which I just thought of, I had a similar problem (but not with a VPN added in), that I couldnt get the MSSQL db showing for the Outlook Business Contact Manager. It turned out the software it self had to share the db, even though I attempted to share it via the SQL admin tools. Also make sure the MSSQL server has TCP/IP naming and connections turned on, as this may affect it too. Hope this is of some use to you.
    0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: