hi there,

i have a question in connecting to the server. when i log in to the server and connect to the ms sql server i can connect to the databases. but when i login to another computer and try to login to the MS SQL server management studio i get an error message saying

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.) (Microsoft SQL Server, Error: -2146893019)

what is the solution for this

6 Years
Discussion Span
Last Post by judithSampathwa

i figured out the answer
if you go to run and type in Cliconfg.exe and then a window will open,
in thath there is TCP/ IP there i had checked force encryption,
that should be unchecked

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.