question

DeepuNair avatar image
DeepuNair asked

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.
sql-server-2005connection
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

one more additional information, (I have made the FORCE PROTOCOL ENCRYPTION = NO ) on the server.
0 Likes 0 ·
Hello, Is there any one to help me in this issue? Please... Thanks and Best Regards, Deepu Nair.
0 Likes 0 ·
I am quite sure that the answer from Matt will fix your problem. If not, let us know.
0 Likes 0 ·

1 Answer

· Write an Answer
Matt Whitfield avatar image
Matt Whitfield answered
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.
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
@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
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.