Sunday, February 19, 2012

Can't connect to sql server 2005 - SSL

Hi,
I Receive this message when I try to connect sql server 2005 express...
Cannot connect to LOCAL\SQLEXPRESS.
===================================
A connection was successfully established with the server, but then an error
occurred during the pre-login handshake. (provider: SSL Provider, error: 0 -
La cha?ne de certificat a été fournie par une autorité qui n'est pas
approuvée.) (.Net SqlClient Data Provider)
I don't have a SSL certificate and i don't want to use it.
Do you have any idea how I can fix it ?
Thanks in advance.
Erik
Forget it...
I found the solution. I ran REGEDIT and remove the
HKLM/SOFTWARE/MICROSOFT/MSSQLServer/CLIENT/...
... and there were a key about SSL (I already forgot the name).
After that, SQL SERVER ran without error.
;o)

No comments:

Post a Comment