x

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

DeepuNair gravatar image

DeepuNair
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

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 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, 2011 at 12:52 AM DeepuNair

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

[1]: http://technet.microsoft.com/en-us/library/cc758128(WS.10).aspx
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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1945
x46

asked: Jan 04, 2011 at 12:34 AM

Seen: 1924 times

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