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 Power BI Enhanced Report Format (PBIR) will soon become the default, and that's a…
Quite a long title for a short blog post :)While deploying a DACPAC (from a…
Yes, you're reading that right, we're going to download a report that cannot be downloaded.…
You can find all the session materials for the presentation "Indexing for Dummies" that was…
The slidedeck and the SQL scripts for the session Indexing for Dummies can be found…
You can find the slides of my session on the €100 DWH in Azure on…