SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Error 26073
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

RammohanB
Starting Member

India
9 Posts

Posted - 01/03/2013 :  11:41:04  Show Profile  Reply with Quote
Hi,

I am getting below error. please provide me quick solution.

Error: 26073, Severity: 16, State: 1.
below error is in event viewer.
TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket. Consider enabling the TcpAbortiveClose SQL Server registry setting and restarting SQL Server. If the problem persists, contact Technical Support.

Thanks



Rammohan

ovc
Starting Member

Romania
35 Posts

Posted - 01/03/2013 :  19:52:03  Show Profile  Reply with Quote
are you using the SQL Server Native Client 10.0?

If yes try to update it with at least SQL Server 2008 R2 CU6 or better SQL Server 2008 R2 SP1 or SP2.

There is a known issue mentioned in the KB article:
http://support.microsoft.com/kb/2491214
Go to Top of Page

RammohanB
Starting Member

India
9 Posts

Posted - 01/04/2013 :  10:16:38  Show Profile  Reply with Quote
we are using sql server 2008 with sp2

Rammohan
Go to Top of Page

ovc
Starting Member

Romania
35 Posts

Posted - 01/04/2013 :  12:33:39  Show Profile  Reply with Quote
Hi Rammohan,

install sql server 2008 sp3 and if you are using windows server 2008 r2 be sure that windows server 2008 r2 SP1 is installed.

This should normally do the trick.

----------------------
As it is written in the article, a workaround would be:
To work around this issue, add the SuperSocketNetlib\Tcp\TcpAbortiveClose value in the registry key for MSSQLServer.

To do this, follow these steps:
Open Registry Editor. To do this, use the appropriate method for your operating system:
In Windows Vista, click Start, type regedit in the Start Search box, and then press ENTER.
In Windows XP, click Start, click Run, type regedit, and then click OK.
Locate and then click the following registry subkey.
For the default instance of SQL Server 2008 or SQL Server 2008 R2, click the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQLServer\SuperSocketNetLib\Tcp
For a named instance of SQL Server 2008 or SQL Server 2008 R2, click the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.(InstanceName)\MSSQLServer\SuperSocketNetLib\TcpOn the Edit menu, point to New, and then click DWORD Value.
Type TcpAbortiveClose, and then press ENTER.
On the Edit menu, click Modify.
Click Decimal, and then type 1 in the Value data box.
Exit Registry Editor.
Restart SQL Server.

------------------
Let me know if this worked. I am curious about it.
Go to Top of Page

ssbhosale3
Starting Member

India
1 Posts

Posted - 01/07/2013 :  04:25:59  Show Profile  Reply with Quote
Hello,

We are also getting similar error on our SQL server in cluster environment

Error 26073
TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket. Consider enabling the TcpAbortiveClose SQL Server registry setting and restarting SQL Server. If the problem persists, contact Technical Support.

Below articles suggest to install CUP 6 on SQL 2008 R2 and a hotfix on Windows 2008 R2
http://support.microsoft.com/kb/2491214

But we are already running on higher version than suggested in above article. Our server is running with SQL 2008 R2 SP1 and Windows server 2008 R2 SP1, still we are getting above error. Has anybody faced similar issue on SQL 2008 R2 SP1. Any suggestion would be appreciated.

Thanks in advance,
SB

Edited by - ssbhosale3 on 01/08/2013 09:04:27
Go to Top of Page

wholesalenfljerseyssale
Starting Member

9 Posts

Posted - 01/11/2013 :  01:27:34  Show Profile  Reply with Quote
unspammed
Go to Top of Page

ThartmefBeame
Starting Member

Austria
1 Posts

Posted - 06/03/2013 :  08:29:45  Show Profile  Reply with Quote
unspammed
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000