| Author |
 Topic  |
|
|
RammohanB
Starting Member
India
9 Posts |
 Posted - 01/03/2013 : 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
Romania
30 Posts |
Posted - 01/03/2013 : 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
|
 |
|
|
RammohanB
Starting Member
India
9 Posts |
Posted - 01/04/2013 : 10:16:38
|
we are using sql server 2008 with sp2
Rammohan |
|
|
|
ovc
Starting Member
Romania
30 Posts |
Posted - 01/04/2013 : 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. |
|
|
|
ssbhosale3
Starting Member
India
1 Posts |
Posted - 01/07/2013 : 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 |
Edited by - ssbhosale3 on 01/08/2013 09:04:27 |
|
|
|
wholesalenfljerseyssale
Starting Member
9 Posts |
Posted - 01/11/2013 : 01:27:34
|
Cheap Jerseys from China online store
The NFL Jerseys Is National Football League (NFL) Cheap Jerseys is the highest level of professional American football in the NFL Replica Jerseys United States. It was formed by eleven teams in 1920 as the American Football Jerseys Wholesale Professional Football Association, with the league changing its name to the National Football League in 1922 Cheap NFL Jerseys. The league is divided evenly into two conferences -- the American Football Reebok NFL Jerseys Conference (AFC) and National Football Cheap Jerseys USAConference (NFC), and each conference has four divisions that have four teams each, for a total of 16 teams in each conference. The Replica NFL Jerseys is an unincorporated 501(c)(6) association, Cheap NFL Jerseys a federal nonprofit designation,NFL Youth Jerseys comprising its 32 teams.
National Hockey League begins with the demise of its predecessor league, Replica NHL Jerseys the National Hockey Association (NHA), in 1917. NHL Jerseys After unsuccessfully resolving disputes with Eddie Livingstone, owner of the Toronto Blueshirts, executives Cheap Jerseys of the three other NHA franchises suspended the NHA, and formed the National Hockey League (NHL), replacing the Livingstone team Cheap NHL Jerseys with a temporary team in Toronto, the Arenas. The NHL's first quarter-century saw the league compete against two rival major leagues--the Pacific Coast Hockey Association and Western Canada Hockey League--for players and the Stanley Cup. The Reebok NHL Jerseys first expanded into the United States in 1924 with the founding of the Boston Bruins, and by 1926 consisted of ten teams in Ontario, Quebec, the Great Lakes region, and the Northeastern NHL Kids Jerseys United States. At the same time, the NHL And NFL Women Jerseys emerged as the only major league and the sole competitor for the Stanley Cup; in 1947, the NHL completed a deal with the Stanley Cup trustees to gain full control of the Cup. The NHL's footprint spread across Canada as Wholesale Jerseys Foster Hewitt's radio broadcasts were heard coast-to-coast starting in 1933.
Baseball has emerged from lots of cheap authentic jerserys ups and down. From the era of dead ball to the modern era, we have seen so many great players reviving this game every year. Until 1920's baseball used to have era known as The authentic jerseys Dead Ball Era. During this time teams use to use same ball for whole game. The ball used to get softened and fewer home runs were scored that era. Cheap jerseys Hitters relied mainly on base hits, single or double for scoring. Since the teams used to use one ball for entire game the people never saw lot of home runs during this era. Baseball saw geat hitter MLB Jerseys and pitchers during that era. Honus Wagner, Ty Cobb played exceptionally at that time and gave hitting a new life. Cy young, Walter Johnson proved that even the ball is dead after few innings they can still pitch the ball where ever they want to. These greats laid the foundation of baseball Cheap MLB Jerseys which we see today in all its glory. World Series started during this period. It was in 1920 when baseball was going through the scandals that Boston Red Sox sent Babe Ruth to New York Yankees for $125,000. And that was a start of the a exciting era for baseball. Babe Ruth played like a hero in Yankees and became one the best player in Baseball. Wholesale Jerseys He hit 54 home runs in his first season in Yankees. During this period of baseball more ball were used during the game. The ball was hard and whiter whole of the game. This helped hitters to score more runs and it made baseball more interesting for people. During this era we saw hitters like Babe Ruth, Lou Gehrig, and Hank Greenberg. After world was II a new era started for baseball.
The National Basketball Association (NBA) is NBA Jerseys the pre-eminent men's professional basketball Cheap Jerseys league in North America. It consists of thirty franchised member clubs, of which twenty-nine are located in the United States and one in Canada. It is an active member of USA Basketball Replica Jerseys Was (USAB),[1] which is recognized by the International Basketball Federation as the National Governing Body (NGB) for basketball in the United States.
Attention Clearance Sale fans! Use the Clearance Sale Categories below to purchase Clearance Sale Apparel, Clearance Sale Gifts and Clearance Sale Merchandise. We are your Jerseys for sale for all the authentic Clearance Sale Gear. Because you are a Clearance Sale fanatic you should have only the best licensed Clearance Sale Apparel guaranteed to show your Clearance Sale Pride. Fanzz only carries licensed Clearance Sale Jerseys, Clearance Sale T-Shirts, Clearance Sale Hats and Clearance Sale Drinkwar |
|
|
| |
Topic |
|
|
|
Error 26073
