What can you recommend for a secure, stable and fast connect for SQL?
Posted on 2010-08-23
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.
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?