Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 681
  • Last Modified:

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

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
Bonne001
Asked:
Bonne001
  • 8
  • 3
2 Solutions
 
DanMarCommented:
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
 
Bonne001Author Commented:
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
 
DanMarCommented:
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
Bonne001Author Commented:
Our ODBC is by IP#.  The Access is a *.ini file.  The router to router tunnel.
0
 
DanMarCommented:
What is the router tunnel exactly?  Is it over the internet?  If you ping the remote sites what latency are you seeing?
0
 
Bonne001Author Commented:
The tunnel is between an RV042 at the server to an RV082 on the remote site.  
I will tested and let you know.
0
 
Bonne001Author Commented:
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
 
Bonne001Author Commented:
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
 
Bonne001Author Commented:
Please close the question no resolution.
0
 
Bonne001Author Commented:
As a work around we are going to use Terminal Server.

Thank you for your help.
0
 
Bonne001Author Commented:
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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