0

I am getting an error while trying to connect to SQL locally either via a web application or SQL management Studio. Oddly, I can connect fine remotely via apps on other servers or SQL management on my desktop.

The error is: SQL - an error occurred during the pre-login handshake.

EDIT I have tried the winsock command listed on the other page I have tried adding tcp:servername,1433 to the Registry as Suggested elsewhere on here. I have tried running this fix it from Microsoft http://support.microsoft.com/kb/2643584 I am still getting the same issue which is that SQL Agent cannot start, if I re-enable SSL3 and reboot all works fine disable again and here is the error i recieve

2014-11-24 21:03:34 - ! [000] Unable to connect to server 'tcp:servername,1433'; SQLServerAgent cannot start 2014-11-24 21:03:34 - ! [298] SQLServer Error: 10054, TCP Provider: An existing connection was forcibly closed by the remote host. [SQLSTATE 08001] 2014-11-24 21:03:34 - ! [298] SQLServer Error: 10054, Client unable to establish connection [SQLSTATE 08001] 2014-11-24 21:03:34 - ! [382] Logon to server 'tcp:servername,1433' failed (DisableAgentXPs) 2014-11-24 21:03:35 - ? [098] SQLServerAgent terminated (normally)

2
  • sorry i did try that
    – rs82uk
    Nov 19, 2014 at 0:26
  • You need to be specific regarding exactly what you tried. Nov 20, 2014 at 8:33

1 Answer 1

0

There are several things it could be, including:

Hopefully, that gives you some things to try.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .