Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Error 26073

Author  Topic 

RammohanB
Starting Member

9 Posts

Posted - 2013-01-03 : 11:41:04
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

35 Posts

Posted - 2013-01-03 : 19:52:03
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

9 Posts

Posted - 2013-01-04 : 10:16:38
we are using sql server 2008 with sp2

Rammohan
Go to Top of Page

ovc
Starting Member

35 Posts

Posted - 2013-01-04 : 12:33:39
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

1 Post

Posted - 2013-01-07 : 04:25:59
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
Go to Top of Page

wholesalenfljerseyssale
Starting Member

9 Posts

Posted - 2013-01-11 : 01:27:34
unspammed
Go to Top of Page

ThartmefBeame
Starting Member

1 Post

Posted - 2013-06-03 : 08:29:45
unspammed
Go to Top of Page
   

- Advertisement -