Solved

What can you recommend for a secure, stable and fast connect for SQL?

Posted on 2010-08-23
11
668 Views
Last Modified: 2012-05-10
Access configured on a local system connecting over a VPN tunnel to a SQL Server.

Remote Server Configuration:  SBS2003 other services running – Exchange
Local stations:  XP O/S – Microsoft Office 2007 – Front end of the SQL server using Access200
      The workstation are on a separate workgroup and not join to the domain.
      The ODBC connection is by IP# rather than server name.
Connection:  Business class cable – VPN router – Remote Server side: RV042 – Worstations (5) RV082
Current Firmware on both

Remote workstations do not have a problem connecting to Exchange or saving files to user directories.

When connecting to the database the following errors occur:
Event ID                  Description
1001                  Fault bucket 01073355
1000                               Faulting Application msaccess.exe, version 8.0.5903, faulting module unknown, version 0.0.0.0, fault address0x000000000.                        
5000      officelifeboathang, p1 msaccess.exe, P2 12.0.6535, PC NTDLL.DLL, P4 5.1.2600.5755, P5 NIL, P6 NIL, P7, NIL, P8 NIL, P9   NIL, P10 NIL.
Etc, etc.

Connecting the systems to the database is slow taking 45 seconds or more sometimes displaying the red delete# in the field until the database becomes available and the data is displayed in the fields correctly.  

My question is:  What is a secure, stable and fast method of connecting to a SQL server?  Terminal server? VPN connection client for each system?
0
Comment
Question by:Bonne001
  • 8
  • 3
11 Comments
 
LVL 5

Expert Comment

by:DanMar
ID: 33508979
What name resolution are you using for the workstations outside the Domain?
You could add domain suffix in DNS section of IP configuration to assist resolution.   What are your DHCP settings for the VPN connection?
0
 

Author Comment

by:Bonne001
ID: 33559613
DanMar,

I was on away from the office for a few days.  

Name resoluton for the outside:  computername.workgroup
DHCP:  On the remote and local stite is on the router

I have changed the following:

Created a zone record in DNS for the workgroup
Changed the etc files to have an entry for the Domain controller

The connection seems to be stable now I need to speed things up.  Any suggestions?

0
 
LVL 5

Expert Comment

by:DanMar
ID: 33564132
Have you configured ODBC & Access connectivity via IP, hostname or fully qualified?
Delays arise due to name resolution issues.  Easiest is IP address.  Ideally to avoid opening ports and increasing security remote users should connect via a VPN.  If not your user & passwords will be in clear text.
0
 

Author Comment

by:Bonne001
ID: 33566467
Our ODBC is by IP#.  The Access is a *.ini file.  The router to router tunnel.
0
 
LVL 5

Accepted Solution

by:
DanMar earned 500 total points
ID: 33566522
What is the router tunnel exactly?  Is it over the internet?  If you ping the remote sites what latency are you seeing?
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:Bonne001
ID: 33627359
The tunnel is between an RV042 at the server to an RV082 on the remote site.  
I will tested and let you know.
0
 

Author Comment

by:Bonne001
ID: 33627451
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\codes>ping 10.10.1.5

Pinging 10.10.1.5 with 32 bytes of data:

Reply from 10.10.1.5: bytes=32 time=20ms TTL=126
Reply from 10.10.1.5: bytes=32 time=22ms TTL=126
Reply from 10.10.1.5: bytes=32 time=17ms TTL=126
Reply from 10.10.1.5: bytes=32 time=20ms TTL=126

Ping statistics for 10.10.1.5:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 17ms, Maximum = 22ms, Average = 19ms

C:\Documents and Settings\codes>

The connection is more stable but it still takes 45 seconds to open the database and sometimes when in the data package it takes time to find the infor.   We are using access on the workstations to pull up the infomation on the SQL server.
0
 

Author Comment

by:Bonne001
ID: 33663179
There is no resolution on this question.  I will try to rephrase the question and resubmit it, as I need to get this resolve today.
0
 

Author Comment

by:Bonne001
ID: 33663195
Please close the question no resolution.
0
 

Assisted Solution

by:Bonne001
Bonne001 earned 0 total points
ID: 33743403
As a work around we are going to use Terminal Server.

Thank you for your help.
0
 

Author Closing Comment

by:Bonne001
ID: 34886329
I appreciate your help Dan Mar and feel you deserve the points.  I just could not do any more troubleshooting the cient needed to move on.


Thank you,
Bonnie
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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.
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

708 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now