Windows 10 shows Limited internet access but it's connected

How I am solving this (works on both win7 and win10) :

All I change on the windows machine are the settings:

  • ActiveDnsProbeContent -> IPv4 address of pihole
  • ActiveDnsProbeContentV6 -> IPv6 address of pihole

Than, on pihole, create a dnsmasq file (I use /etc/dnsmasq.d/09-msftncsi.conf), content:

host-record=ncsi.localdomain,192.168.2.57,2a02:1810:xxxx:6902:4bec:yyyy:a97b:zzzz
cname=www.msftncsi.com,ncsi.localdomain
cname=dns.msftncsi.com,ncsi.localdomain
cname=ipv6.msftncsi.com,ncsi.localdomain
cname=www.msftconnecttest.com,ncsi.localdomain
cname=ipv6.msftconnecttest.com,ncsi.localdomain

edit
modified the dnsmasq file to overcome an earlier mentioned problem (unknown status in the query log)
/edit

Create the web server files:
file /var/www/html/connecttest.txt, content:

Microsoft Connect Test

file /var/www/html/ncsi.txt, content:

Microsoft NCSI

now restart pihole-FTL to activate the new dnsmasq config file.

verify everything checks out, by entering

the content of the web server file should be displayed.

The connection test icon in windows is now OK

edit
don't do this if the machine leaves your (home) environment, the IP address changes on the windows machine will cause a problem.
I had to do this on my old windows 7 desktop, since I disconnected it from the internet, but allow access to the (home) environment)
/edit