Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2010-08-23
11
Medium Priority
?
680 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
[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
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 2000 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
 

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

670 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