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

VPN troubles

I am connecting into a clients computer over a VPN.  I can connect fine, however i am getting an error in a program because it can not connect properly.  The program is Ultimate Collection Control Client.  The error i am gettin is "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."  Any clue as to what this can be and how I can solve it?

Thanks in advance
0
securi-tech
Asked:
securi-tech
  • 3
  • 3
  • 3
2 Solutions
 
MarakushCommented:
When you setup the user DSN via ODBC use the IP address rather then the host name.

Marakush
0
 
securi-techAuthor Commented:
I'm sorry but you lost me, could you elaborate a little more?
Thanks
0
 
MarakushCommented:
To create a DSN

WIN XP
http://support.microsoft.com/default.aspx?scid=kb;en-us;305599

WIN2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;300596

The error that you posted, something is trying to connect to an SQL DB when you create the DSN use the IP of the SQL server rather then the Name of the SQL server. Because it sounds like it isn't resolving correctly.

Marakush
0
What Security Threats Are We Predicting for 2018?

Cryptocurrency, IoT botnets, MFA, and more! Hackers are already planning their next big attacks for 2018. Learn what you might face, and how to defend against it with our 2018 security predictions.

 
HypercubeTechCommented:
Marakush is right... Also check to make sure you can access folders on the network or if you can ping the server via name and not ip (or see if you can by both to make sure the connection is good).. Which VPN server are you using.

0
 
securi-techAuthor Commented:
Windows 2000, for some reason i dont think the vpn is configured right.  I can connect but no luck on pinging or finding anything on their side of the network!  I know this is not the right forum but any help will be appreciated.  I tried the above answer and still not working.
0
 
MarakushCommented:
Well there is the problem if you can't ping it, or see it on the network that's a whole other problem.

We need to look at the VPN configuration to see what is going on, this issue will most likely be resolved when you  access the network on the other side.

Okay first things first.

How are you making the VPN connection? What is the configuration you are using?

Point to Point via routers? Client to Router? Client to Server? Hardware and software you are using? Also have to tested both connections and verified that both connections are up and running with net access?

Marakush
0
 
HypercubeTechCommented:
And what type of router are you using.. some routers have a built in VPN server which makes things VERRRY easy..
0
 
securi-techAuthor Commented:
It was client server, the machine was an old nt server.  I convinced the person to buy a vpn router.  Thank god...its a one more problem of my plate

Thanks for the help
0
 
HypercubeTechCommented:

No prob.. I have used some SMC ones.. older but under 100 bux   SMC7004FW i think it is
might be able to find them still..
0

Featured Post

What Security Threats Are We Predicting for 2018?

Cryptocurrency, IoT botnets, MFA, and more! Hackers are already planning their next big attacks for 2018. Learn what you might face, and how to defend against it with our 2018 security predictions.

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