Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Data Access

[DBNETLIB][ConnectionClient(SEDC.ClientHandshake()).] SSL Server error

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?

[371 byte] By [Puzzled] at [2007-12-24]
«« What does it mean for an executable to be "signed and validated"?
»» Add Version Control Folder to My Favorites
# 1
Puzzling - Received Same error....Any assistance would be helpful.
Scooby91 at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Data Access...
# 2

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.

MINGLV at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Data Access...
# 3

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/

NanTu at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Data Access...
SQL Server
SQL Server Data Access

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified