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.

more ▼

asked Jan 04, 2011 at 12:34 AM in Default

avatar image

11 1 1 2

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

Jan 04, 2011 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, 2011 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, 2011 at 04:40 AM WilliamD
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jan 04, 2011 at 12:48 AM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

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, 2011 at 12:52 AM DeepuNair

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

Jan 04, 2011 at 03:15 AM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 04, 2011 at 12:34 AM

Seen: 2217 times

Last Updated: Jan 04, 2011 at 02:06 AM

Copyright 2018 Redgate Software. Privacy Policy