February 8, 2013 at 1:55 am
Hi,
Server OS - win 2008 R2 enterprise edition 64 bit
Database - SQL server 2008 R2 enterprise edtion 64 bit
SQL SP - Service pack 2
Application server - Connected to Virtuval machine
DATE/TIME:2/8/2013 12:15:44 PM
DESCRIPTION:A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 64, output error: 0).
please suggestion me, how to resolve this issues?
I have checked as below query, it is return 1024 records
SELECT * FROM sys.dm_os_ring_buffers where ring_buffer_type='RING_BUFFER_CONNECTIVITY'
output
<Record id = "40670" type ="RING_BUFFER_CONNECTIVITY" time ="7882701651"><ConnectivityTraceRecord><RecordType>LoginTimers</RecordType><Spid>0</Spid><SniConnectionId>C3727202-5CD9-456A-9224-656B29B129E8</SniConnectionId><SniConsumerError>17830</SniConsumerError><SniProvider>7</SniProvider><State>11</State><RemoteHost><![CDATA127.0.0.1]></RemoteHost><RemotePort>3014</RemotePort><LocalHost><![CDATA[server IP]]></LocalHost><LocalPort>1433</LocalPort><RecordTime>2/6/2013 14:37:48.80</RecordTime><TdsBuffersInformation><TdsInputBufferError>10054</TdsInputBufferError><TdsOutputBufferError>0</TdsOutputBufferError><TdsInputBufferBytes>0</TdsInputBufferBytes></TdsBuffersInformation><LoginTimers><TotalLoginTimeInMilliseconds>0</TotalLoginTimeInMilliseconds><LoginTaskEnqueuedInMilliseconds>0</LoginTaskEnqueuedInMilliseconds><NetworkWritesInMilliseconds>0</NetworkWritesInMilliseconds><NetworkReadsInMilliseconds>0</NetworkReadsInMilliseconds><SslProcessingInMilliseconds>0</SslProcessingInMilliseconds><SspiProcessingInMilliseconds>0</SspiProcessingInMilliseconds><LoginTriggerAndResourceGovernorProcessingInMilliseconds>0</LoginTriggerAndResourceGovernorProcessingInMilliseconds></LoginTimers></ConnectivityTraceRecord><Stack><frame id = "0">0X00000000017D1F3B</frame><frame id = "1">0X00000000017CED26</frame><frame id = "2">0X00000000017D39AE</frame><frame id = "3">0X0000000000A867EC</frame><frame id = "4">0X0000000000987688</frame><frame id = "5">0X000000000043AB94</frame><frame id = "6">0X000000000043B05E</frame><frame id = "7">0X000000000043AD57</frame><frame id = "8">0X00000000009151DE</frame><frame id = "9">0X0000000000915395</frame><frame id = "10">0X0000000000918925</frame><frame id = "11">0X00000000009159D6</frame><frame id = "12">0X0000000074D637D7</frame><frame id = "13">0X0000000074D63894</frame><frame id = "14">0X000000007700652D</frame><frame id = "15">0X000000007713C521</frame></Stack></Record>
December 27, 2013 at 1:07 pm
Hi,
I am getting the same error... did you got any success with resolving the error.
Thanks
December 27, 2013 at 9:09 pm
For the above errors need to check as bleow points
1. N/W connection break and not stable
2. application not able to connect with user name & password which was mention exists configuration.
3. server ip address changed
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply