I am unable to connect to SQL Server, instead I get
Sql Server ErrorL 18
Handshake error as above
A connection was successfully established with the server, but then an error occurred during the pre-login handshake (provider: SSL Provider, error: 0- The token supplied to the function is invalid) (Microsoft SQL Server)
Any ideas?
Puzzling - Received Same error....Any assistance would be helpful.|||Can you provide more detail info:
1) Were you connecting to SQL Server 2005 or SQL 2K?
2) Is it remote connection or local?
3) What OS of client side and what OS on server side?
4) Did you specify any certificate on your server side?
5) Which account did your sql service running under?
Thanks!
Ming.
|||Mostlikely, you turn on the SSL encryption on client side by using cliconfg or in the connection string. However, the certificate used by server is not trusted by your client.
If your server is 2005, http://blogs.msdn.com/sql_protocols/archive/2005/10/04/476705.aspx
If your server is 2000,
http://support.microsoft.com/kb/276553/
No comments:
Post a Comment