Monday, June 21, 2010

SuperSocket Info: Bind failed on TCP port 1433

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

snip ------
reference here

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
the following:

netsh winsock reset

This fixed the problem! See this article on Microsoft for more info:
Q811259. Hope this saves other people time. ----

No comments:

Post a Comment