I didnt' try the below but I went through the network connection utility and just re-applied the settings (also removed named pipes but test this first). I'm guessing that this rebuild the stack for sql as well
I recently began getting this error when SQL Server 2000 starts up. I
tried all the suggestions I could find (e.g., Q293107) but none worked.
I did finally figure this out and wanted to share the solution.
It turns out my winsock2 had been corrupted (by Juniper VPN software, I
believe), resulting in SQL Server attempting to bind twice to the same
socket. From the command line (on my windows XP SP2 machine), I ran
netsh winsock reset
This fixed the problem! See this article on Microsoft for more info:
Q811259. Hope this saves other people time. ----