As the title suggests I have an Access frontend application with a backend MS SQL 2014 (express) server used in a small environment with a few workstations. This is working ok on Win 7 & 8 using the hosts file to point at the backend. However, with Win 10 it completely ignores the hosts file entry and terminates in error (cannot find SQL server). If I instead use the IP address in the ODBC connection string it works. Strangely ping for the hostname works ok!

Any clues?

Hi,

Please try following suggestions:

1. Run PowerShell as Administrator

2. Set-SmbClientConfiguration -RequireSecuritySignature 1

Answer Y when prompted to confirm the modification.

3. Set-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters" RequireSecureNegotiate -Value 0 -Force

If the issue still persists, consider if the new version of SMB is not supported and Windows 10 failed to access the server DB:

Control Panel -> Programs -> Turn Windows features on or off ->Enable "SMB 1.0/CIFS File Sharing Support"

Let's see if we can get it work fine.