• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 741
  • Last Modified:

Unable to connect to SQL server via PPTP VPN

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
johnny_the_knife
Asked:
johnny_the_knife
  • 3
1 Solution
 
theoaksCommented:
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
 
johnny_the_knifeAuthor Commented:
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
 
johnny_the_knifeAuthor Commented:
I am now seeing a new error: Unable to create sspi context.
0
 
johnny_the_knifeAuthor Commented:
Problem remains unresolved.  Other solutions being examined.
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now