Solved

Unable to connect to SQL server via PPTP VPN

Posted on 2009-04-12
4
713 Views
Last Modified: 2012-05-06
I use an application which connects to a SQL server hosted on a Windows 2000 box which is also a domain controller and VPN server.  When I am connected locally to the network with my Vista Business laptop, everything works normally.  When I connect to the network via VPN, I can map network drives hosted on the same server as the sql database, can ping the database server, but can't connect to the SQL server using the application, ODBC or Managent Studio.  I receive an error that basically reads:

"The server was not found or was not accessible"

I have searched Google etc but can't find any solutions.  The server is running on port 1433, I have added an exception to the Windows Firewall on the laptop for my application, and have tried connecting using both SQL and Windows integrated authentication.

I log onto the laptop using cached credentials, and the VPN authenticates against the domain.
0
Comment
Question by:johnny_the_knife
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 5

Expert Comment

by:theoaks
ID: 24129370
have you enabled sql remote connections.

i think in sql 2000 its done through Network Utility.

or for 2005 its through surface area configuration.

azz


0
 
LVL 7

Author Comment

by:johnny_the_knife
ID: 24134144
Remote connections are enabled in that I can connect to the SQL server from hosts other than the server on the local network, just not via VPN.
0
 
LVL 7

Author Comment

by:johnny_the_knife
ID: 24267556
I am now seeing a new error: Unable to create sspi context.
0
 
LVL 7

Accepted Solution

by:
johnny_the_knife earned 0 total points
ID: 24408853
Problem remains unresolved.  Other solutions being examined.
0

Featured Post

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
IPSec Site to Site VPN Topology 6 70
Server 2012 L2TP VPN Windows client to server 10 39
Cisco Anyconnect for Android 6 44
Replication failure 1 23
Some of you may have heard that SonicWALL has finally released an app for iOS devices giving us long awaited connectivity for our iPhone's, iPod's, and iPad's. This guide is just a quick rundown on how to get up and running quickly using the app. …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question