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.
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.