Solved

ODBC SQL connection not working over PPTP VPN

Posted on 2013-02-01
10
1,713 Views
Last Modified: 2013-03-12
We had a workstation connecting to a SQL server over a normal LAN.  Everything worked.  We had to move this workstation to a new office but wanted to still have access to this software.  We disjoined the workstation from the domain, moved it, and connected it to the VPN.  This is the error we get when opening the software. "Invalid user authorization specification: invalid user ID or password" We've reinstalled the software, and are 100% sure that the user ID and password is correct in the ODBC settings.  We had the software company login and they spent hours working on this but insist it's a networking issue, which I agree since it worked fine before the move. I've also disabled all firewalls on both ends including the firewall on the network adapters.  client pc is XP connecting to server 2003 standard.  Also, I am using the domain admin account for testing to connect.
0
Comment
Question by:Sean Rhudy
[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
  • 5
  • 3
  • 2
10 Comments
 

Author Comment

by:Sean Rhudy
ID: 38844456
P.S.  I can ping and browse the server with no issues.
0
 
LVL 78

Expert Comment

by:arnold
ID: 38846188
The situation is not the same since the system is no longer a member of the domain.


What is the authentication mode for the application using odbc are you using sql login or are you using or is the application using windows authentication mode. Now that that the system is not a member of the domain, the credentials used to login into the system do not match the required authorization to access the sql.
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 38847418
make sure odbs dsn  is set  with sql server valid sql server login\password  and if TCP\IP protocol  with port set too.

you need to make sure the new network setup of this PC has ability to see sql server port
default is 1433 - but you may have another (check on the sql server)
telnet from pc to this server port 1433
and you may need to open this port that will let this pc to see sql srrver
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 43

Expert Comment

by:Eugene Z
ID: 38847420
<100% sure that the user ID and password is correct in the ODBC settings. >
does it mean when you open DSN properties - you cam get to the test form - and test connectivity was successful?


if is it -- it is probably this software setup problems-- > looks like you need to check this apps   connection string that may use another login
0
 

Author Comment

by:Sean Rhudy
ID: 38849048
Yes, the test connectivity is successful.  ODBC is set to use SQL credentials, not windows authentication.
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 38849145
check with the vendor  to check the apps connection string  - . you may have there something different than you have in DSN
0
 

Author Comment

by:Sean Rhudy
ID: 38849298
I could rejoin the domain over the VPN, do you think that would be a smart troubleshooting step?
0
 
LVL 78

Expert Comment

by:arnold
ID: 38849320
Do you have sql login auditing enabled for failure? Look to see whether you have failed login attempts from the remote system looking at what username is being provided by the remote system and see whether it is an SQL or a remotename\username.

Rejoining the domain is not the only thing, you would also need to login into the system using AD credentials which in he current state would require the establishment of he VPN prior to making any login attempts.
0
 

Accepted Solution

by:
Sean Rhudy earned 0 total points
ID: 38866708
We tried everything above, couldn't get it to work.  We changed to a TS server.
0
 

Author Closing Comment

by:Sean Rhudy
ID: 38976820
Nothing else worked.
0

Featured Post

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

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

How to set-up an On Demand, IPSec, Site to SIte, VPN from a Draytek Vigor Router to a Cyberoam UTM Appliance. A concise guide to the settings required on both devices
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

705 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