Application (which uses Microsoft SQL Server 2008 R2 Express) Is Very Slow Over Windows VPN

-

hi!

work small company department me, appreciate can get. company comprised of 8 computers (all windows 7 – 32, others 64 bit) in small lan , 1 single windows 2008 server r2 on cloud vpn, nat, application server , else. basically, trying put our resources on our server in cloud, including new educational application have purchased. application uses sql server 2008 express r2 database.

i configured server (via remote desktop connection) routing , remote access including vpn , nat. so, when computers in office connect vpn via pptp, able internet through server fine excellent speed. however, application bought crawling on windows vpn. mean, takes 2-3 minutes information popup in screen when first open application. after that, takes 1-2 minutes each single action when browsing through application … when test odbc connection in odbc data source administrator screen (from of our windows 7 machines), takes less second test complete successfully.

below steps have taken in vain fix issue:

  1. i have disabled 'use default gateway on remote network’ in vpn connection, however, odbc connection fails when that’s disabled. so, forced turn on, application remains slow.
  2. i’ve enabled qos in router in our small lan - application remains slow.
  3. i’ve tried adding manually our server dns properties of vpn connection – odbc fails connect.
  4. i have tried disable netbios on tcp/ip – odbc fails connect.
  5. i’ve uninstalled , reinstalled nic cards on windows 7 workstations – application remains slow.
  6. i have disabled tcp/ipv6 on vpn connection – application remains slow.

i have feeling solution problem maybe related sql server 2008 r2 express validating each step of way on pptp windows vpn…. when use remote desktop connection, application works fine off server... also, think changing vpn protocol (maybe l2tp) may solve issue?

 i appreciate if can shed light issue.    

thanks in advance!!!

hi,

thanks posting here.

is vpn connection show application need connect sql server express? if remote desktop server working fine, maybe packet format or size impact speed. or impacted sql performance. however, not expert sql server, not sure this. suggest post issue @ sql server forum. may effective suggestion there.

sql server forums

http://social.msdn.microsoft.com/forums/en/category/sqlserver

slow database connection on vpn

http://social.msdn.microsoft.com/forums/eu/sqldataaccess/thread/6b6bc6bb-0fb7-4975-a997-7f1f87512bad

best regards,

aiden

aiden cao

technet community support



Windows Server  >  Network Infrastructure Servers



Comments

Post a Comment

Popular posts from this blog

Group Policy Event ID 1058 Error Code 1326 (The user name or password is incorrect)

-
i seeing odd error on 1 of our domain controllers. have dealt event id 1058 errors whereby policy (or policies) not replicating, receiving error along error code 1326 on server, , apparently happening default domain policy: log name:      system source:        microsoft-windows-grouppolicy date:          8/10/2015 3:09:54 pm event id:      1058 task category: none level:         error keywords:      user:          s-1-5-21-1484152634-2550175353-3916092219-3287 computer:      <dc name>.<domainname> description: processing of group policy failed. windows attempted read file http://schemas.microsoft.com/win/2004/08/events/event ">   <system>     <provi...
Read more

Suspicious event log Event ID: 4905

-
hi thr, could please me understand causing such event logs generate ? as  i understand, vssvc.exe pertains volume shadow copy used backup purpose.  we have third party application used taking backup of servers. the event longs generated following messages: 1) attempt made unregister security event source. 2) attempt made register security event source. these events not regular generated on random days. standard fields: date:               2013/10/19 time:               02:32:19 importance:         critical rule name:          security event monitored machine:  <domain controller> log format:         windows log name:           security event id:           4905 in work hours:      yes dynamic fields: internal timestamp: 2013/10/19 ...
Read more

DCOM received error "2147746132" from...

-
hi everybody, i have dc (my windows essentials 2012 server) , windows 2012 server in network.  the windows server 2012 inside domain. on server, got "non stopping" error says in event logs : ===> dcom received error "2147746132" fromd computer xxxx(my dc computer) while server trying activation : {6df8cb71-153b-4c66-8fc4-e59301b8011b} it never stops, got 11000+ new events :s i found : http://support.microsoft.com/kb/971153/fr i'm not sure should ? does got idea ? matthieu. hi, please try solution mentioned in below link: http://www.eventid.net/display-eventid-10006-source-dcom-eventno-272-phase-1.htm regards, cicely Windows Server  >  Windows Server 2012 General ...
Read more