Note: not a SQL/BI related post like usual, but since it’s a common issue I want to share my solution here
Quite recently I had a bizarre issue on my laptop: suddenly I could only browse Google websites (Google search, YouTube, Gmail …). All the other websites would time out or give error messages. On my mobile phone however, I could browse normally using our home WiFi network. I plugged my laptop in a wired UTP connection, but the result was the same: only Google websites. The browser didn’t matter: I had the same issue in Chrome as in Internet Explorer. Rebooting didn’t solve the issue. Since I only had the problem on my laptop, I (incorrectly) assumed it was a problem on my machine only.
Time to Google for a solution. It immediately became clear that a lot of people had encountered a similar issue and that there are a lot of different possible fixes:
So for some reason I still had a valid IPv6 address, but not an IPv4. I checked the Event Viewer and bingo! Several DHCP-related errors were logged. Now I had an idea in which direction I had to search. I saw people had issues because their router blocked port 80, but that was not the case here. Finally I found a forum post where someone had the same issue because they had recently installed a security camera, which was connected to the network. The camera had a small router inside and it was throwing off the DHCP of the normal router. Did I have something similar at home? And then it hit me: the wireless access point at the attic! Apparently I forgot to turn off DHCP when I installed the access point. For some reason, after several weeks of functioning just normal, the access points got delusions of grandeur and said to the network: “You know, this DHCP thingy? I’ll take care of that”. Badly, it seemed. So we unplugged the access point and everything started working again. Big sigh of relief.
Conclusion: if you have the weird issue where suddenly you can only browse Google websites (aka websites with IPv6), check if there’s a component in your network that can also provide DHCP services (aside from your main router) and turn it off.
The slides for my session "The €100 data warehouse on the Azure data platform" can…
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited the…
It's the second tuesday of the month, which means T-SQL Tuesday time! This month's topic…
It's time for T-SQL Tuesday again! And we're almost to number 200! T-SQL Tuesday is…
A while ago we suddenly had an error while trying to deploy one Fabric workspace…
I've uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my DataGrillen…