I reached a high state of euphoria today, I managed to prove that I could fix server problems along the more Administrative lines than I have done before.
Our shiny new IBM server with Windows 2008 installed on it was causing it problems. Nothing has been changed in the last few days but all of a sudden, remote access was down and the SQL Client side server manager was failing to connect.
We first thought that there was a problem with SQL, but upon further error messages I received when trying to connect remotely, I decided to go with the fact it was a server problem and not an SQL problem. My first forum lead me to a couple more where they said this had been fixed, and when I managed to find the answer in amongst the ‘thank-you’ messages, I decided to have a go.
This forum said to go to Control Panel and then Network settings. View the Status and click on configure for the Network Card, then disable IPv4 Large Send Offload.
This should solve all your network problems, it did mine, and I was promptly hoisted on the shoulders of my colleagues and carried round the factory in the usual hero parade.