How to solve this Remote Connection Issue.

Posted by Jayakumars under Sql Server on 4/9/2015 | Points: 10 | Views : 5176 | Status : [Member] [MVP] | Replies : 13
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


Responses

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

Up
0
Down
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

Up
0
Down
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

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

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

Up
0
Down
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

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

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

Up
0
Down
Hi
Can you come online i mention my issues for sql server connection issue.

Mark as Answer if its helpful to you

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

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

Up
0
Down
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

Up
0
Down
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

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

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

Up
0
Down
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

Up
0
Down
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

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

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

Up
0
Down
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

Up
0
Down
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

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

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Login to post response