cancel
Showing results for 
Search instead for 
Did you mean: 

SQL TCP Error

SOLVED
Go to solution
Darren Etheridge_2
Super Advisor

SQL TCP Error

We have a new DL380 with 20GB of RAM. Primary Drive is Mirrored & the Remaining 6 Drives are RAID 5. THe Server is a SQL 2005 Enterprise Server (32 bit). and this morning our SQL Instance failed with the Error:

Server TCP provider has stopped listening on port [ 1433 ] due to a failure. Error: 0x2736, state: 2. The server will automatically attempt to reestablish listening.

I have looked thru the web & microsoft site for this error (how & why it happens) but really didnt turn up anything.

Has anyone encountered this error? What Causes it?

Thanks in advance.

Darren
2 REPLIES
Rune J. Winje
Honored Contributor
Solution

Re: SQL TCP Error

What SP and CU level are you at?

SQL 2005 without SP or SP1 is very buggy.

With SP2 marginally ok.

With SP2 and Cumulative Update 10 at the latest & greatest.
http://support.microsoft.com/kb/956854/


For Proliants also go with the latest PSP - 8.11 at time of writing, which includes the latest network drivers.

You may also want to try and disable SNP - at least just to test and see if it makes a difference:
http://support.microsoft.com/kb/948496


Cheers,
Rune
Phil.Howell
Honored Contributor

Re: SQL TCP Error

does netstat -e show errors?
are you using NC373i nics?
if so, update to latest psp
Phil