asked
MS SQL Server error,what causes it?
I get following error message while attempting to connect to a MS SQL Server: **A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 – The specified network name is no longer available.) (Microsoft SQL Server, Error: 64)**
Does this stack exchange question help?
https://dba.stackexchange.com/questions/57455/sql-server-connectivity-issues What is going on with the SQL Server when you try to attempt to connect? How are you attempting to connect? Through SSMS? An application?
It could be a limit on connection pooling. It also could be too many open connections. Be sure your apps are closing their connections when they're done. [Here's a good blog post][1] on MSDN for troubleshooting this error. [1]:
http://blogs.msdn.com/b/spike/archive/2009/04/16/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.aspx
[
https://social.technet.microsoft.com/Forums/itmanagement/en-US/373cf033-d3f1-4f71-af02-a8a6b8d05828/sql-database-is-corrupted-plz-help?forum=sqltools][1] [1]:
https://social.technet.microsoft.com/Forums/itmanagement/en-US/373cf033-d3f1-4f71-af02-a8a6b8d05828/sql-database-is-corrupted-plz-help?forum=sqltools
20 People are following this question.
