How to solve this Remote Connection Issue.

Posted by Jayakumars under Sql Server on 4/9/2015 | Points: 10 | Views : 16834 | Status : [Member] [MVP] | Replies : 15

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

I have connect my sql server I meet this issue . But I set Tcp-ip Enabled also my ipaddress also enabled but i canot connect i am struggling this issue for connect the database very urgent any one help me

My Issue this

ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the pre-login handshake.
(provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)

An existing connection was forcibly closed by the remote host

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Bandi on: 4/9/2015 [Member] [MVP] Platinum | Points: 25

0	http://relyonsoft.com/techsupport/?p=1273 Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jayakumars on: 4/9/2015 [Member] [MVP] Bronze | Points: 25

0	Hi Bandi can you provide your email id please. then i set this option in my sql server but did not clear Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jayakumars on: 4/9/2015 [Member] [MVP] Bronze | Points: 25

0	Hi bandi not working Still now same issue. Yes i follow this url set tcp-ip enabled but i canot connect Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jayakumars on: 4/9/2015 [Member] [MVP] Bronze | Points: 25

0	Hi Can you come online i mention my issues for sql server connection issue. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bandi on: 4/9/2015 [Member] [MVP] Platinum | Points: 25

0	Hi, Are you able to login with SystemName\SQLInstanceName ? Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jayakumars on: 4/9/2015 [Member] [MVP] Bronze | Points: 25

0	Hi ofcourse i tried also like this i canot connect . I do know what is the issue? Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bandi on: 4/9/2015 [Member] [MVP] Platinum | Points: 25

0	check second solution in the below link https://arshpreet9.wordpress.com/2011/05/06/sql-server-error-233-when-connecting-locally-and-sql-error-10054-when-connecting-remotely/ Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jayakumars on: 4/9/2015 [Member] [MVP] Bronze | Points: 25

0	Hi Bandi this url http://https//arshpreet9.wordpress.com/2011/05/06/sql-server-error-233-when-connecting-locally-and-sql-error-10054-when-connecting-remotely/ not working right now Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bandi on: 4/9/2015 [Member] [MVP] Platinum | Points: 25

0	https://arshpreet9.wordpress.com/2011/05/06/sql-server-error-233-when-connecting-locally-and-sql-error-10054-when-connecting-remotely/ Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jayakumars on: 4/9/2015 [Member] [MVP] Bronze | Points: 25

0	hi can you check this url https://arshpreet9.wordpress.com/2011/05/06/sql-server-error-233-when-connecting-locally-and-sql-error-10054-when-connecting-remotely/ not working go to malware detection also Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bandi on: 4/9/2015 [Member] [MVP] Platinum | Points: 25

0	2) When connecting remotely: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 – An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054) It may be the SQL Server got installed with Window Authentications only. So changing the authentications to “SQL Server and Window authentication” might fix the problem (as mentioned in the below thread.) http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/968cd292-5a3f-4c48-9347-4604a6fa9872 –But in my case, I can’t even connect to the management studio. So this wasn’t possible as well. Option 2 ruled out as well. Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

2) When connecting remotely:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 – An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)

It may be the SQL Server got installed with Window Authentications only. So changing the authentications to “SQL Server and Window authentication” might fix the problem (as mentioned in the below thread.)
http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/968cd292-5a3f-4c48-9347-4604a6fa9872
–But in my case, I can’t even connect to the management studio. So this wasn’t possible as well. Option 2 ruled out as well.

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 4/9/2015 [Member] [MVP] Platinum | Points: 25

0	check 4) Enable Remote Connection in the below link http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/ Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bandi on: 4/9/2015 [Member] [MVP] Platinum | Points: 25

0	Have you got solution for the issue ? If yes, share the solution as well as what was the problem... Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Lazyhorse on: 4/5/2018 [Member] Starter | Points: 25

0	I had this issue, and was solved. It was something to do with SSL/TLS hardening (we changed both ciphers, and protocols). Not too sure what caused it - but our SQL server was running on Windows Server 2003 :-\| After installing this windows patch for Server 2003 we could login from our clients again. KB Article Number(s): 948963 Cheers - Hope this helps. Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

I had this issue, and was solved.

It was something to do with SSL/TLS hardening (we changed both ciphers, and protocols). Not too sure what caused it - but our SQL server was running on Windows Server 2003 :-|

After installing this windows patch for Server 2003 we could login from our clients again.
KB Article Number(s): 948963

Cheers - Hope this helps.

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Self-Innovator on: 6/25/2018 [Member] Bronze | Points: 25

0	You can try the below two options 1.Update the client computer to the server version of the SQL Server Native Client 2. Go to regedit.exe ->Add the following registry key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\ DWORD SynAttackProtect 00000000 Join Hands Change lives Thanks & Regards Straight Edge Society Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

You can try the below two options

1.Update the client computer to the server version of the SQL Server Native Client

2. Go to regedit.exe ->Add the following registry key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\

DWORD

SynAttackProtect

00000000

Join Hands Change lives
Thanks & Regards
Straight Edge Society

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts