https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/247641&feed=atom&action=history
Microsoft KB Archive/247641 - Revision history
2024-03-28T17:49:01Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/247641&diff=136160&oldid=prev
3155ffGd: importing KB archive
2020-07-18T16:13:44Z
<p>importing KB archive</p>
<p><b>New page</b></p><div><div id="nsbanner"><br />
<br />
<div id="bannerrow1"><br />
<br />
{|<br />
| Knowledge Base<br />
|<br />
|}<br />
<br />
<br />
</div><br />
<div id="TitleRow"><br />
<br />
= <span id="KB247641"></span>FIX: Trusted TCP/IP Socket Connection May Fail with Error Message 18452 =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="BOTTOM"><br />
<br />
Article ID: 247641<br />
<br />
Article Last Modified on 3/14/2006<br />
<br />
<br />
-----<br />
<br />
APPLIES TO<br /><br />
<br /><br />
<br />
* Microsoft SQL Server 7.0 Standard Edition<br />
<br />
<br />
-----<br />
<br />
<div class="notice_section"><br />
<br />
This article was previously published under Q247641<br />
<br />
</div><br />
<div class="notice_section"><br />
<br />
BUG #: 56445 (SQLBUG_70)<br />
<br />
</div><br />
<div class="symptoms_section"><br />
<br />
== SYMPTOMS ==<br />
<br />
Under certain situations, a client may fail to connect to SQL Server 7.0 when using TCP/IP sockets and Microsoft Windows NT authentication (trusted connection), and the following error message is displayed:<br />
<div class="errormessage"><br />
<br />
Error 18452: Login failed for user 'null'. Reason: Not associated with a trusted SQL Server connection.<br />
<br />
</div><br />
When using full-text search, the error message displayed is as follows:<br />
<div class="errormessage"><br />
<br />
Server: Msg 7619, Level 16, State 1, Line 1 Access is denied.<br />
<br />
</div><br />
Typically, after this error message occurs, no other clients can make new connections until SQL Server is restarted. Both TCP/IP sockets and Multi-Protocol clients may experience this problem. Named pipes clients are not affected.<br />
<br />
</div><br />
<div class="cause_section"><br />
<br />
== CAUSE ==<br />
<br />
This problem is more likely to occur when both Multi-Protocol and TCP/IP sockets trusted connections are attempted from the same client computer. Connection stress also makes the problem more likely to occur.<br />
<br />
</div><br />
<div class="workaround_section"><br />
<br />
== WORKAROUND ==<br />
<br />
Use one of the following workarounds:<br />
* Use trusted connections over named pipes where appropriate.<br />
* Disable multiprotocol for SQL Server using the Server Network Utility.<br />
<br />
<br />
</div><br />
<div class="status_section"><br />
<br />
== STATUS ==<br />
<br />
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:<br />
<div class="indent"><br />
<br />
[[../254561|254561]] INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0<br />
<br />
<br />
</div><br />
For more information, contact your primary support provider.<br />
<br />
</div><br />
<div class="moreinformation_section"><br />
<br />
== MORE INFORMATION ==<br />
<br />
This same error message may occur under normal SQL Server operations when many simultaneous trusted connections are attempted through TCP/IP sockets. This is due to the server and network being too busy, causing SSPI communication timeout, which in turn causes trusted connection timeouts. However, these intermittent connection timeouts will not affect SQL Server accepting new connections, and should not be a cause for concern.<br />
<br />
</div><br />
<br /><br />
<br />
Additional query words: integrated security RPC<br />
<br />
Keywords: kbbug kbfix KB247641<br />
<br />
<div class="footer"><br />
<br />
<br /><br />
<br />
<br />
-----<br />
<br />
[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]<br />
<br />
<span>© Microsoft Corporation. All rights reserved.</span><br />
<br />
<br />
</div><br />
<br />
</div></div>
3155ffGd