четверг, 15 февраля 2018 г.

Connection to MS SQL Server slows down via WiFi (TP-Link Archer C2, AC 750 router)

Situation

I bought and installed a new TP-Link Archer C2, AC 750 router

Found strange slows down when connecting to a remote MS SQL Server database

When connecting by cable, the connection speed with the database is almost instantaneous (up to 1 second)

Through the wi-fi connection to the base took 35 seconds (although the overall speed of the wi-fay is almost the same as the cable)

With the old D-link dir 300 router, there were no such problems. The laptop did not change. The provider did not change.

I use EMS SQL Manager for SQL for database coneection
https://www.sqlmanager.net/en/products/mssql/manager


What did not help


Switched to different 2.4 and 5 MHz bands
Played with subtle settings WiFi (channel, channel width, Package, WPS) - all useless


What helped


It turned out that it was in the settings for WiFi authorization

in the web interface of the router (usually access through http://192.168.0.1/)
section
Wireless Security

defaults:

Authentication type: WPA2-PSK
Encryption: AES

It was necessary to change the encryption to TKIP

Note: to change the encryption from AES to TKIP it was necessary to disable WPS mode for one of the channels (this is also done via the web interface of the router.) The section is called "WPS")

I want to note the support service TP-Link.
Although the modem is home-use, but I was not left alone with the problem. Manager Vyacheslav Didenko contacted me and we spent more than an hour dealing with the situation. Good job!

2 комментария: