question

RRRDawson avatar image
RRRDawson 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)**
sqlerror-message
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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?
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WHicks avatar image
WHicks answered
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.