SQL 2000 Port 1433 no longer listening
-
Does anybody know a way to restart or reinitialise a port in SQL.
We have an intermittent fault where SQL port 1433 drops and is no longer listening for connection requests.
So far, the only way I know to reinitialise the port is to restart SQL Server Service.
Can anyone help?
Many Thanks
Ian
-
Ian,
What is leading you to believe that it is a port problem? What is the error that you are seeing on the client side when attempting to connect?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
David,
When I do a portqry, port 1433 is no longer listening and is not accepting remote connections. To rectify, I am having to restart the SQL service, then, when I do a portqry on 1433, it's listening and remote connections are successfully connecting again.
Ian
-
And the server is behaving normally otherwise, i.e. CPU utilization is normal? Very curious......
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
Yes, all seems normal. I'm just trying to figure out a way to wake up port 1433 without having to restart SQL.
-
Understand BUT, you might also want to figure out what is killing the port. That is totally abnormal behavior. Also a bit suspicious.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
-
Have you used this tool http://support.microsoft.com/kb/837243 to see what is using the port at the time you are unable to communicate to it. Wondering if it is totally inactive at that time....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply