Until yesterday evening, J'étais able to connect to mon server depuis mon local machine. Now, I get le suivant error:
**A connection was successfully established avec le server, mais alors an error occurred pendant le pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) (.Net SqlClient Data Provider)**
Note, I can log on to le actual server avec no problem.
Yesterday, I installed IIS on mon machine et set up a site using mon IP address - ne know si this has anything to do.
I did come across this article, followed le steps, mais didn't seem to help.
[http://escapekeys.com/microsoft-sql-server-error-64-a-connection-was-successfully-established-with-the-server/89](http://escapekeys.com/microsoft-sql-server-error-64-a-connection-was-successfully-established-with-the-server/89)
I aussi went through le suivant article, changed TC/IP settings, restarted, mais nothing.
[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/](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/)
Started trying suggestions depuis comments too mais stopped quand I realized I might be messing things up more.
So, why is this happening / how can I fix?
SQL - une erreur s'est produite pendant la négociation de pré-connexion
Re: SQL - une erreur s'est produite pendant la négociation de pré-connexion
An answer propsed here:
[http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/2d11b6f9-3ada-4682-b643-c721a97af4ba](http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/2d11b6f9-3ada-4682-b643-c721a97af4ba)
>
Sick of le problem? Dont know ou care what winsock is ou tout of this
low level crap means.
Allez dans a command prompt
do this
`netsh Winsock reset`
go on avec votre life et be happy.
[http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/2d11b6f9-3ada-4682-b643-c721a97af4ba](http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/2d11b6f9-3ada-4682-b643-c721a97af4ba)
>
Sick of le problem? Dont know ou care what winsock is ou tout of this
low level crap means.
Allez dans a command prompt
do this
`netsh Winsock reset`
go on avec votre life et be happy.