SQL Server 2005, Client Connectivity Issue.

Hi all, can anyone help me to sort this issue.

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (.Net SqlClient Data Provider)

this happens only from one server & all other servers are able to connect to this SQL server (2005)

Thanks in advance.

asked Jan 04 '11 at 12:34 AM in Default

DeepuNair
11 ● 1 ● 1 ● 2

one more additional information, (I have made the FORCE PROTOCOL ENCRYPTION = NO ) on the server.

Jan 04 '11 at 12:48 AM DeepuNair

Hello, Is there any one to help me in this issue? Please...

Thanks and Best Regards, Deepu Nair.

Jan 04 '11 at 04:32 AM DeepuNair

I am quite sure that the answer from Matt will fix your problem. If not, let us know.

Jan 04 '11 at 04:40 AM WilliamD

(comments are locked)

1 answer:

You may need to add the root certificate that was used to create the original certificate to the trusted certificates store on the client machine. You haven't specified what O/S is in use, so it's hard to provide links to more specific help.

answered Jan 04 '11 at 12:48 AM

Matt Whitfield ♦♦
29.2k ● 56 ● 63 ● 87

Hi Matt, the OS is Windows 2003 Standard edition, and the Server OS is Windows 2003 Enterprise edition. The SQL Server is SQL Server 2005 Enterprise Edition.

Jan 04 '11 at 12:52 AM DeepuNair

@DeepuNair - in that case, the information you need is here: click me

Jan 04 '11 at 03:15 AM Matt Whitfield ♦♦

(comments are locked)