N/APosted on - 08/21/2011
I am trying to install SQL server but during installation I am facing this error and I don’t why this error occurs. Please tell me its detail. Need very urgent Solution.
Detail of Error:
Retrieving the list of recent order summaries failed. (mscorlib)
Dao Proxy: unable to intercept method name ‘FinalAllSummaries’, cause: A transport-level error has occurred when sending the request to the server. (Provider: TCP Provider, error: 0 – An existing connection was forcibly closed by the remote host.)(IBatisNet.DataAccess)
A transport-level error has occurred when sending the request to the server. (Provider: TCP provider, error: 0 – An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)
Thanks in advance for providing help.
SQL Server Non Fatal Error
I am somewhat confused by the error message you got when installaing your SQL Server. (Microsoft SQL Server, Error: 10054)
This error message is invoked only when the server receives too many connection requests that it surpasses the queue, or on server restart instance, the queued connection requests are doubled, that you might have to flush the queue.
This is a failover sequence, built in within the code, to protect the server when there are too many requests of which the server interprets as a SYN attack. This is usually corrected by disabling the SYN process in Registry but this will open your server to possible multiple simultaneous connection requests and will shut your server down.
A comprehensive workaround, is still being devised by the SQL DEV team to address this issue. Hope this helps.