Windows 10: Cloned HDD and network/DNS issues connecting to MySQL server?

Hi there,

I have a rather perplexing problem. Our work "server" (Desktop PC serving database information to workstations) has been displaying some unusual behaviour. Our practice management software used a MySQL database on the server.

Many months ago, Windows performed an update and we lost the ability for several workstations to connect to the database. The database responded with an error: "can't get hostname for your address". I decided I was going to restore a backup, but rather than overwrite the existing HDD, I purchased a drive EXACTLY the same - a 1TB WD Blue (WDC WD10EZEX-08WN4A0). I used DDRescue to clone the drive. Once the backup was restored everything ran as before and this became our new HDD.

Windows has just updated to 1803 on the server (and others) but it hasn't gone as planned. Our entire update history has been removed so we can't rollback. Anyway, I decided to clone the drive back to the original HDD first, then restore a backup from prior to the update. Lucky I tested the drive first.

When the original HDD was used, the same network connectivity issues returned. Although I can browse the shares and access the database folder on the server using Explorer, we once again have the dreaded "can't get hostname for your address" error. Switching back to the other HDD alleviates the error and the database is accessible again.

What the hell is going on here? It doesn't make any sense to me...

Thanks gurus.

Nick

:)

 

DNS server suggestions.


Hiya.

I need some suggestion on good DNS servers that I can connect to and not find myself with problems all the time, I've used FF, Chrome, Edge and Comodo Dragon but all seem to have issues especially with the DNS that I'm connected to.

I'm currently using the Google one, but if you know any good ones then please suggest it!

I've also read about having my own DNS server but that just seems as a big crambamboli.

And if you think that it's my internet that is having a stroke or something:




Cheers, Boris

 

Computer can't connect to DNS server

Below are standard troubleshooting steps. Most of these you have already tried. Try the remaining ones.

First you should run Internet Connections / Network / Hardware & devices Troubleshooter and then execute Microsoft recommended troubleshooting steps. Update me once done.

A. Run Internet Connections / Network / Hardware & Devices Troubleshooters

Windows Key+I > Update & Security > Troubleshoot >

1. Click Internet Connections > Run the Troubleshooter

2. Click Network adapters > Run the Troubleshooter

3. Click Hardware & Devices > Run the Troubleshooter

B. IP and DNS Setting

Type ncpa.cpl in Windows start > Right click on your network > Properties > Select Internet Protocol Version 4 (TCP/IPv4) > Hit properties > Make sure below ones are checked

Obtain an IP Address Automatically

Obtain DNS Server Address Automatically

You can also try Google DNS

Select Use the following DNS Server Addresses > Preferred DNS Server - 8.8.8.8 > ALternate DNS Server - 8.8.4.4

Try Open DNS

Select Use the following DNS Server Addresses > Preferred DNS server : 208.67.222.222 > Alternate DNS server : 208.67.220.220

C. Head to following Microsoft Help Link and execute the steps there

https://support.microsoft.com/en-us/help/10741/...

 

DNS server causing problem

Hi Andrea,

DNS is a server that translates websites' addresses so that browsers can connect to them. If the addresses become outdated or the server has issues, problems and DNS errors occur. For us to provide an accurate solution, we would need you to answer the following
questions:

• Which build, version and edition of Windows is installed on your computer?
• What changes have you made to your device before this issue occurred?
• Are you experiencing the same issue regardless if you are trying to be connected to a wired or wireless connection?

For initial troubleshooting, we suggest deleting the DNS cache. This can refresh the DNS files and settings on your PC. Follow these steps to delete the DNS cache:

• Using Search type Command Prompt.
• Form the search results, right click on Command Prompt (Desktop app) and then choose Run as administrator.
• In the Command Prompt window, type ipconfig /flushdns and then hit the Enter key.
• Once done, restart your computer and then check if the same issue persists.

We are looking forward to your response.